consolidate data

[Louise]

Once again, I need your help
I need to consolidate data from different workbooks in a particular directory into one summary workbook.
The problem is that I do not know the name of these workbooks which will be created at a later date usin
a template. The template will have name ranges to identify the particular cells that need to be consolidated

Example
C:\Folder\SubfolderA\Workbook
\Workbook
\Workbook


\SummaryWorboo

Any ideas

I appreciate your help
Louise

 

[Frank Kabel]

Hi
as a starting point see:
http://www.rondebruin.nl/copy3.htm

 

[Louise]

Thanks! I think that's exactly what I needed