Summary sheet from tab names

  • Thread starter Thread starter Joe F
  • Start date Start date
J

Joe F

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
 
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
 
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)
 
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
 
Back
Top