Hi ,
I have an excel file where Column A contains a list of paths to various other Excel files.

E.g
c:\file1.xls
d:\file2.xls
c:\folder\file3.xls

I want a macro that opens each file in the list and picks the value in cell A1 of each excel file and populates another excel file with the values in A1.