Say you wanted to see cell C1.

Enter the name of the worksheet in A1, and try this formula:

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

As you change the name in A1, you'll reference C1 in that particular sheet.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jhyatt" wrote in message
...
I need to se if there is a formula to return a specific cell on a worksheet
but the worksheet name changes on occasion.