I'm not a Mac user, so forgive me if this advice is inappropriate.
I would use the HYPERLINK worksheet function.
To link to cell Z3 on sheet Sheet2, with text "Product A":

=HYPERLINK(CELL("address",Sheet2!$Z$3),"Product A")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup