I may have asked this before but I can't easily find it in "My Answered Questions". And in this version I am asking for a slightly different "solution".
I have a bunch of excel files in one folder. Each one has 1 workpage. They all have the same column headers.
I want to combine those files into one workbook. They can each be a different page of the workbook or, even better, they can be combined into one workpage -- since they all have the exact same structure and headers.
Any solutions to do that?