I think you can use union only if data coming from same spread sheet. I think in your case you can drag spread sheet only associated to ReponsesSU15 excel file, cannot drag spread sheets of OutcomeSurveyReport12 or any other excel file. I'm not sure about this.
Hi there -- You can union sheets from different files. The current union is from two different files, just trying to add a third file.