I have an Excel question. I have a workbook with multiple sheets. I'd
like to create a table of contents so that if I click on a link, it
will switch over to the appropriate worksheet. How can I do this?

Hello Sharontucci,

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:
 [1] Select menu Insert -> Hyperlink...
 [2] Select "Document" on the Insert Hyperlink window that appears and
then "Locate" near the bottom (in the area titled "Anchor").
 [3] 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.
 [4] 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).
 [5] 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
  worksheet link
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
further.

Good luck with your work.
  --Maniac

Excellent assistance. Thank you.