=A1&"!$A$1"

Is that what you're looking for?
--
-SA


"Susan" wrote:

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?