Clean up repeating excel file expansions

Morning,

I have a folder structure filled with a large number of excel files, all with identical layout but differing data in multiple tabs.
I can easily set up a monitor of the folder to pull in the sheets and expand the tabs into individual tables merged across all the excel sheets,
All this I can accomplish but the UI creates a set of Transform File folders and query for each tab/table combination and it just seems to be a bit redundant. I have no problems with pulling the data in, all the files match and such, it is just irritating that there are like 5 folders/files for every single tab I create a table from. Seems like there should be a cleaner way to merge the individual tabs out into a table for multiple excel sheets? Any ideas?