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)

Rick Wilson wrote:

How do I create a hyperlink from one place to another within a worksheet so
that when the worksheet is copied, the hyperlink references to the copied
worksheet and not the original sheet. (Excel 2003)
Thanks

--

Dave Peterson