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)

nastech wrote:

Is there a way to mix use of HYPERLINK, and CELL functions, where reference
to CELL might move with line as document expands / contracts (where line
moves, in line positon). ABSOLUTE cell perhaps.

problem is that "in-document" hyperlink does not maintain integrity for
position.

=HYPERLINK(CELL("row",B469),"x") not working

--

Dave Peterson