Code to pull data from 100+ workbooks into 1 sheet. Is this impossible?

[matthewjapp]

I have a drive location where there are 350-400 workbooks with data I need to merge into 1 worksheet.

There is no naming convention as retards in an un-named department here haven't a clue how to manage data.

Each workbook has data in cells D5:D7, then D10:D14, then D17:D19 and finally D22:D23

So need 1 workbook with 13 columns bringing in data from each workbook.

I've scratched my head long and hard and am now where the real brains of the outfit are

Any takers on this one?

 

[Sektor]

See message.