Hi everyone,
I have several Excel workbooks, each containing a couple dozen spreadsheets. The workbooks have different names and so do the spreadsheets, and simply mass consolidating doesn't help with the issue I need to solve.
I've been trying to find a way to consolidate them all in a way that would display the following output in a single spreadsheet:
Column A: Name of origin file. (Not an absolute must, but would help.)
Column B: Name of origin tab/spreadsheet.
Columns C-End: Content of said spreadsheet.
Does anyone know how can I accomplish that? Either in Access or in Excel...
Thanks in advance!
Bookmarks