Import specific cells in multiple sheets from hundreds of identical workbooks

Are all the cells on the same sheet name in the workbook? Different sheets?

I can conceive of a tool where you provide:

1) A starting folder
2) name of a sheet
3) A list of cell addresses

And a macro collects the data from all the found files in that one folder.

Here's a sample file I created for someone else along the lines of what I described above.

A true "database" would be one row equals an entire dataset. So what is really needed is data dictionary for your new master worksheet.

You could set it up by creating a multi row header as a descriptive map:

Row1 you would list the sheet name
Row2 you would list the cell address on that sheet
Row3 you would be the title you want for the column of data.

I would recommend the first column be called FILENAME so as data is imported the complete file/pathname can be listed for reference, and to insure we do no ever import the same workbook more than once.

With that layout, it's easy to create a macro to go through all the workbooks in a folder and collect all the info based on the sheet names and cell addresses.