=INDIRECT("[myBook.xls]"&A1&"!A1")

but the other workbook must be open.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matt D Francis" wrote in message
...
Hi,

I have a worksheet which needs to does a calcualtion on data in another
workbook containing several worksheets.

Workbook 1 has something like

Col A Col B
Apr-05 =formula
May-05 =formula


Workbook 2 has several worksheets called
Apr-5
May-5


So I need my formulas in Workbook 1 to find the appropriate worksheet in
Workbook 2 (identified in the adjacent) before doing their calcualation.

It looks like I need to use maybe the INDIRECT function, or named ranges
but
I can't quite get it...

Any suggestions?

Cheers,

Matt