What you ask is straight forward using what Excel calls a "Hyperlink".
I created a sample worksheet where the first sheet has the "table of
contents" and the second & third sheet are linked from that contents
sheet. I started with a new worksheet (which defaults on my system to
three empty sheets named "Sheet1", "Sheet2", and "Sheet3".
On Sheet1, I created some descriptive labels in column A (A1 refered
to the contents, A2 to the second sheet, A3 to the third sheet).
On Sheet1, I created the hyperlinks in column B as follows:
 Select menu Insert -> Hyperlink...
 Select "Document" on the Insert Hyperlink window that appears and
then "Locate" near the bottom (in the area titled "Anchor").
 Another window appears, requesting a cell reference. If you have
a named cell on the destination sheet, you could select it below or
enter the reference directly (e.g., Sheet2!A1) and then OK.
 The reference appears at the top of the Insert Hyperlink window
and a similar value is filled in as "Display". I suggest you change
that to the phrase describing the destination sheet. Change the tool
tip if desired as well (the default tool tip is the path to your
worksheet / destination cell).
 When the values are entered as desired, enter OK.
For each cell you do this to, the contents of the cell look like a
hyperlink in a web page. The cursor changes when you hover over one of
these links as well (looks like a hand on my system). Click on it to
test / take you to the other sheet.
Repeat the above steps for each cell / sheet to be linked. Adapt the
names / cell locations to fit your needs.
NOTE: If you rename the destination sheet - you have to fix the
hyperlink (at least with my version of Excel) that points to it. Use a
right click to bring up a pop up menu and use Hyperlink... again to
make the fix.
To find this information, I searched the Excel help using phrases like
and after viewing the Hyperlink documentation, was able to test the
method / prepare the answer.
If a part of the answer is unclear or does not quite meet your needs -
please make a request for clarification. I would be glad to help
Good luck with your work.