Create database from several Excel workbooks - VBA or another way?

[NMullis]

Good afternoon,
I have 10 existing workbooks that follow the same general structure from which I need to combine information into a flat, query-able file. Attached is a reduced version of one of the workbooks. These workbooks could have up to 18 PG tabs with each tab containing 0-300 products, each product has 23 rows of data though I only need a few lines.

I have a tab called "Desired Flat File" that shows what I want the end result to look like. Obviously I used the double lines to indicate where it would normally continue to copy all of the information but I skipped it just for a quick visual.

What is the best way to accomplish this? VBA or another method? I should mention the actual workbooks are quite large because of many lookup formulas, 70+MB.

Thank you for your help!
N

[kalbasiatka]

The files are in one folder?

[NMullis]

Yes, the files are all in the same folder on a network drive.

[kalbasiatka]

Sorry for the delay

Please Login or Register  to view this content.