Heterogenous Worksheet/Spreadsheet Consolidation, with a twist

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!

Hey,

First off - thanks for your reply.

All workbooks are in the same folder, that much - at least - is in order.
As to columns A/B - there are two options:

1. One name per row until the end of copied information per worksheet X.
2. One name at the first row of copied data, per worksheet copied.

Now, since the worksheets are not homogenous, and have different amounts of rows/columns, perhaps a set definition of rows to copy would be of help.
I know for a fact that I only need to copy about 15 columns per worksheet, and approximately 50 rows per worksheet - so that's a possible limit that would unify the code.

An optimal final result would be something like this:

Picture1.png

Bump!
Does anyone have an idea...?