Wattkisson,

You could use the INDIRECT function, but the linked workbook must be open.
Other than that, I think your only solution will be to create the formula
with a macro.

Often a project is split into separate workbooks (and separate worksheets),
when it should be in fewer (or one) workbook. Consider that carefully; it
might be what you need.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"wattkisson" wrote in message
...
I want to set up a workbook with several values from linked workbooks. I
would like to enter a value in column A and then use that value as the
filename in the rest of the cells that link to the external workbook.
For example:

I want to enter A122 into colum A - and have the cell in column B pick
that
value up and link to a cell in an external workbook with that name

Obviously, the following function links correctly to the external file and
returns the correct value:
='G:\Local files\Sample Tracking\[A122.xls]Sample Request'!$E$2

But, I do not want to have to change the syntax in a large number of cells
everytime I add to the list. I only want to enter the value (A122) in the
first cell and have the others retrieve linked values correctly.
In other words, I want a dynamic, external link.

Thanx in advance for any help.