Marcotte,

Use the INDIRECT function to do this. E.g.,

=INDIRECT("'"&A1&"'!L32")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Marcotte A" wrote in
message
...
I have a summary page in my workbook that has the individual
sheet names listed in column A. Is there a way to reference the
cells in column a within a formula so that the formula pulls the
info from the appropriate page?

This is what I want the end result to be.....
A B
1 Sheet1 ='Sheet1'!L32
2 Sheet2 ='Sheet2'!L32
3 Sheet3 ="Sheet3'!L32

but I would like to replace the " 'Sheet1'! " etc. with a
reference to cells A1, A2 etc.