Excel - Link The Tab Name into Worksheets

Can I link the Tab Name, ie Sheet1 or Sheet2 into a worksheet as a title? ie "Please see 'Sheet1' for more information. "
Thus, if the 'Sheet1' tab is changed to 'Bod' then it's changed throughout all the worksheets.

 

Hi Dishon,
I do not see why not - but I will try it after posting this.
I would say say you need a cell on Sheet1 that is a hyperlink to Sheet2.
The cell on Sheet1 will automatically show the hyperlink text on mouseover.
will get back to you on this . . .
regards

 

Use VBA

This function would give you the sheet name
----------------------
Function sheetname() As String

Dim wsThisone As Worksheet

Set wsThisone = ActiveSheet

sheetname = wsThisone.Name

Set wsThisone = Nothing

End Function
-----------------------

If you then enter the equation "=sheetname()" into a cell on the sheet in question, the cell content will be the sheet name. You can then reference that as normal.

However, note that the link isn't live and you may have to update it or trigger it in another way to get it to update. Double clicking on the cell will do it.