Cell linked to a different sheet name

[Quality Geek]

I want to link a cell to a different sheet name within the same workbook, so that when I change the name on the name of the sheet tab the name will change on another sheet. I loaded an example of what I am wanting; for example, a sheet is named J. Bubba and that name will appear on the Summary Recap sheet. So when I change the name on the J. Bubba sheet tab to B. John the name on the Summary Recap will change also. Is this possible?

Thank you!

[oeldere]

Yes, it's possible (see the attached file)

Please Login or Register  to view this content.

[ChemistB]

My take on what you are asking. You want to be able to change a sheet name and on your summary sheet, it will automatically come up with the new name.

Here's what you have to do. On each of those other sheets, you need to dedicate a cell to having this formula

Please Login or Register  to view this content.

(typed exactly like that)
Then reference that cell on your summary sheet. If you change the sheet name, the cell will change and your summary sheet will follow suit. Work for you?

EDIT: Added attachment

[Quality Geek]

Thank you both for your quick replies. oeldere, thank you for your formula. ChemistB, you hit it just right, works perfectly.

[ChemistB]

Glad you got it. Thanks.