Automatically Create Table Of Contents For Workbook

[kadrleyn]

If the workbook contains many sheets , a table of contents can be created to navigate easier between the sheets.
This process can be done with macro codes.

This macro will create a new sheet at the start of the workbook named "Workbook_Index" when workbook opened. If this sheet already exists it will remove it and will rebuild. The macro will then list the names of all the sheets in the workbook and insert a hyperlink for each one.Also,can be returned to table of contents when the "Esc" key is pressed while on any sheet.