Consolidating multiple workbooks

[Guest]

I have to deal with about 100 workbooks which are functionally identical
including the workbook name. Each is stored in a separate folder.

I need to create a consolidated workbook which includes data obtained by
references to certain cells in each of these workbooks.

The following reference works:
='G:\Folder_Name\[Workbook]'!Cell_Reference

I need to be able to supply a different folder name for each workbook but I
cannot construct anything that will work.

As all the workbooks have the same name, I cannot have more than one open at
a time.

Any help would be very much appreciated.

 

[Harlan Grove]

I have to deal with about 100 workbooks which are functionally identical
including the workbook name. Each is stored in a separate folder. ....
I need to be able to supply a different folder name for each workbook but I
cannot construct anything that will work.

....

See

http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/ac443753560f0075

(or http://makeashorterlink.com/?F2993260A ).