I'd use the =hyperlink() worksheet function.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Jackson wrote:

Can anybody tell how I can change the name of a worksheet (Tab) within a
Excel workbook and have the hyperlink recognize the name change of the tab.
--
Andrew Jackson

--

Dave Peterson