The change should be automatic. Start with a new workbook and in a cell in
Sheet1, enter:

=Sheet2!B6

Then go to Sheet2 and re-name it jim. Then go back to Sheet1 and the
formula will have automatically changed to:

=jim!B6

--
Gary''s Student - gsnu200823


"Joe F" wrote:

I have been racking my brain on how to make this work! I have created a
workbook with 70 tabs and a summary sheet linking to specific info on each
worksheet. I would like to be able to change the tab name and have that
change on the summary sheet as well. Is this possible?

Examble tab name is currently generic "Person 1" Summary sheet is also
(manually) entered as "Person 1" I want to be able to rename the tab to Jim
Smith and have that update on the summary sheet as well.

I have not worked with macros

Thanks

Joe