I have a spreadsheet which pulls 3 sets of data from approximately 40
different files.

I need to update the referred path of each cell every week.

Is there a way to make "partial" path names in seperate cells and
essentially create the total path by referring to those cells?

Example:

A1: "'c:\"
A2: "Excel\"
A3: "Project\"
A4: "[Test.xls]Sheet1'!$B$2"

Then refer to A1, A2, A3, A4 to create a cell reference to
"'c:\Excel\Project\[Test.xls]Sheet1'!$B$2"

This way, I could simply change the data in a few cells and and update my
whole spreadsheet.

-Working on Excel 2003-

Thanks for any input!

Dan