Link from one worksheet to another

Go to Insert and select  Link.

Select the This Document tab.

Type a destination or choose the worksheet name and select OK.

Go to Insert and select  Hyperlink.

Select the second radio button, Location in this file.

Type the other worksheet name and a cell separated by an exclamation point and select OK. For example Sheet2!G15 or Accounting!A1.