Summary Worksheet from Multiple Workbooks
 

I need a function or VBA macro that will allow me to pull data located in the
same cells in different workbooks. Each row of the summary sheet should
correspond to a different workbook. The structure of each row looks like
this:

Path Col 1 Col 2
c\My Docs\[File 1] Path&Sheet1'!$C$5 Path&Sheet3'!$Z$10

Any suggestions? Thanks.

Summary Worksheet from Multiple Workbooks
 

Try
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"eddie_zoom" wrote in message ...
I need a function or VBA macro that will allow me to pull data located in the
same cells in different workbooks. Each row of the summary sheet should
correspond to a different workbook. The structure of each row looks like
this:

Path Col 1 Col 2
c\My Docs\[File 1] Path&Sheet1'!$C$5 Path&Sheet3'!$Z$10

Any suggestions? Thanks.