check out indirect()
=indirect("'C:\["&B1&"]Finance'!$E9+...

"Mark T" wrote:

Looking to sum up several workbooks into one master consolidated book.
Want to have the list of names of files to sum up taken from a range,
like:

Col A Col B
FILE1 Actual file1 name here (could change)
FILE2 Actual file2 name here (could change)
FILE3 Actual file3 name here (could change)

The formula to sum the data is in each Cell on the master book (and is
the SAME Cell as on the individual sheets, just taking the data from
each one and summing it).

Would look something like this:

='C:\[FILE1.xls]FINANCE'!$E9+'C:\[FILE2.xls]FINANCE'!$E9'C:\[FILE3.xls]
FINANCE'!$E9

The File names could change but it shouldn't matter because the link is
looking for the range names FILE1, FILE2, FILE3.

It doesn't seem possible to get the links to work when the source is a
range name.

Any ideas?