=INDIRECT(A1&"!A1")

The first A1 refers to the cell with the sheet name (in your case 'sheet1'),
the second A1 pulls out the value from cell A1 in the referenced sheet.

Joerg Mochikun


"Susan" wrote in message
...
I'm working in Excel for Inventory. I made several worksheet in a file.
I want to make a summary page for each worksheet.
I want: when I put the worksheet name in A1 cell, B1 cell refer this name
as
worksheet name like:
A1: sheet1
B1: sheet1!$A$1
when I change A1 to sheet2, B1 should chang to: sheet2!$A$1

Anyone knows how to do it?