I searched the internet for a solution, but could not find one that works. I do not have MS Query.
And I do not want to use; copy *.csv ConsolidatedFile.csv I would have to save every file as a csv (now xlsx files).
I have several excel files, some of these files have several "sheets" to them.
I wish to have file "1" to be consolidated/placed in "sheet1" of the master consolidation file, and file "2" in "sheet2," etc.
This might be easy for xlsx files that have only one sheet.
It could be that for those files that have more than one sheet, they would simply be copied into the next sheet. This would be acceptable.
Is there an easy way of doing this? There are too many files to do it manually.