Don's suggestions could make it easier but changing the names of 223 files in
223 folders may be an onerous task.

If you could get J:\Projects\ORF\Meeds\xlsx\005\ and all other paths into a
list a loop through could be done although getting the list may also be onerous.

After all, the workbook name............ORF.xls...........and the worksheet
ORF_Change do not vary from folder to folder so what the code would do is loop
through the path names pulling data from each workbook into a sheet in your
Master workbook


Gord


On Thu, 23 Jun 2011 06:39:03 -0700 (PDT), carl wrote:

Thanks again. This file structure was a result of decompressing. I
used winzip to do the decompression. So if I can get the file path
details into a spreadsheet we might be able to do the extract - J:
\Projects\ORF\Meeds\xlsx\005\ORF.xlsx ?