Howdy, and welcome to the board.
Do you mean like a hyperlink? Click cell A1 on Sheet1. Then go to Insert > Hyperlink. In the resulting dialog box, on the left select "Place in this document". Then on the right, select the sheet where you want to go and above that type in the cell where in that new sheet you want to be.
HTH