software

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] Pathamp;Sheet1'!$C$5 Pathamp;Sheet3'!$Z$10

Any suggestions? Thanks.

Try
www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;eddie_zoomquot; gt; wrote in message ...
gt;I need a function or VBA macro that will allow me to pull data located in the
gt; same cells in different workbooks. Each row of the summary sheet should
gt; correspond to a different workbook. The structure of each row looks like
gt; this:
gt;
gt; Path Col 1 Col 2
gt; c\My Docs\[File 1] Pathamp;Sheet1'!$C$5 Pathamp;Sheet3'!$Z$10
gt;
gt; Any suggestions? Thanks.