For union check this link: - Analyzing Related Data on Multiple Excel Tabs | Tableau Software
For more clarity check this link: - Defining Custom Joins with the Custom SQL Option | Tableau Software
Hope this may help!
Thanks Prashant, that does what I need!
The ideal interface though would be to be able to select the files from the new connection dialog and click "Union" .. I'll see if that can be added as a feature