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.