Insert a hyperlink to the cell in Sheet2:
CTRL + K.

You can't do that, however, for sheet 2, or your text in A1 will show the hyperlink...