Hyperlink to a cell containing a reference

Here is a revision that is copy-and-pastable.

Formula:

=HYPERLINK("[hyperlink.xlsx]"&SUBSTITUTE(CELL("address",Sheet2!A1),"$",""),Sheet2!A1)