Use the INDIRECT function. Let's say your vaiable name is stored in cell A1.

=INDIRECT("L:\Budget\2008\"&$A$1&"\["&$A$1&"2008Budget.xls]Consolidated!C10)

HTH,
Elkar


"Steve" wrote:

Hi. I have multiple spreadsheets and a "consolidated" sheet that ties them
all together. Right now, I have a formula in each cell that refers back to a
different spreadsheet to get the
data(=+'L:\Budget\2008\Susan\[Susan2008Budget.xls]Consolidated'!C10)

That is working fine, but what I would like to do is have the name "Susan"
in a cell and have the formula refer to the cell that the name "Susan" is in
to create the formula. So, if I change where I want the data to come from, I
only have to change the name in the cell that "Susan" is in. So if I changed
Susan to Mike, the formula would read:
=+'L:\Budget\2008\Mike\[Mike2008Budget.xls]Consolidated'!C10

Any ideas?