What it does
Creates a table of contents sheet at the front of your workbook, listing out each sheet in your file as a hyperlink.  It can optionally add a link on each sheet back to the table of contents (you can set the cell in each sheet where that TOC link is inserted).

When to use it
When you want to efficiently navigate the sheets in your workbook and have a table of contents.

Why to use it
This helps navigate and provide direction to other users of your workbook.

Default shortcut
None

Other Details

• Category: Sheets / Navigation
• Difficult: 2/5
• Usage/frequency: 4/5
• Automation factor: 5/5 (estimated 300 seconds saved each time used)
• Type: Bulk
• Date added: 1/1/2014
• Tags: sheets, contents

Related Macros
Sheet Action Picker

Other Articles
None

Table of Contents – Example File

Prerequisites
None.

Instructions
Run the Table of Contents macro.  You will be prompted whether to insert hyperlinks back to the TOC in each sheet within your file and which cell to insert them in (leave blank for none).  The Table of Contents sheet will be added as the first sheet in your workbook.  A hyperlink for each sheet will be included based on each sheet’s position/index.

Hidden sheets will be displayed as hidden rows in the TOC.  The sheet tab color will be used as the fill color for each sheet listed in the TOC.  To refresh the Table of Contents, simply run the Table of Contents macro again and elect to overwrite the existing Table of Contents sheet at the prompt (you may want to rename the old one if there are any notes or adjustments on it).