Summary sheet from tab names
 

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

Summary sheet from tab names
 

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

Summary sheet from tab names
 

If you are using a macro instead of a formula to populate you will need to
change the name in the macro or refer to the sheet by its index or sheet.

sheets("sheetname")
sheet1
sheets(1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joe F" <Joe wrote in message
...
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

Summary sheet from tab names
 

Codename is the one you would want so you can move around and rename

Sub sheetsid()
name
MsgBox Sheets("sheet11").Range("d2")
codename
MsgBox Sheet12.Range("d2")
index
MsgBox Sheets(6).Range("d2")
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
If you are using a macro instead of a formula to populate you will need to
change the name in the macro or refer to the sheet by its index or sheet.

sheets("sheetname")
sheet1
sheets(1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joe F" <Joe wrote in message
...
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