I just figured it out:
=HYPERLINK("#"&CELL("address",Sheet2!A6),"?")


"Bob" wrote:

I'm trying to create a hyperlink on Sheet1 that will take me to a cell on
Sheet2 when clicked. The formula I created is:

=HYPERLINK(Sheet2!A6)

But when I click on the link, I receive the following error message:
"Cannot open the specified file."
Can anyone tell me how to fix my formula so it works?
Thanks, Bob