Hello List,
Is there another method to reference a cell in an external
workbook other than the function indirect? The workbooks
that I need to reference will reside on a server and will
be closed when a refresh is made to the consolidating
workbook.

Assume the following:
* Book1.xls is located at: \\Server\ProductType\
* Book1 Contains Sheet named Profile
* Sheet Profile has a cell $A$1="Needed Output"

Book2.xls is a consolidating workbook that references many
external workbooks.
* Book2 Contains a sheet named "Setup"
* In Setup three columns exist where the user types the
path of a specified workbook (\\server\productType\), the
file name (book1.xls) and the name of the profile sheet
(Profile). A fourth column concantenates the column and
places them int the appropriate form (lets' call it Cell
D2 which equals '\\Server\ProductType\[Book1.xls]Profile'!)
* Cell b1 of Sheet2 needs to reference the path from the
Setup sheet and reference cell $A$1 (of book1)

I've tried =Profile!D2 & $A$1 but it doesn't work..
Basically I need the above to be interpretted as
='\\Server\ProductType\[Book1.xls]Profile'!$A$1


Any Suggestions would be greatly appreciated.
Jeff