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)



Bill wrote:

Hi,
I have an excel file with a number of different work sheets say, wksheet1,
wksheet2 and wksheet3.
Is it possible to use the hyperlink function to switch between work sheets?
For example, if I'm on wksheet1 and want to switch to wksheet2 can I click
on a hyperlink which is written as wksheet2 to switch to wksheet2.

Thanking you in advance.

--

Dave Peterson