Navigating a large spreadsheet (continued)...
This addin installs a CommandBar with a drop down list of all the visible worksheets in the workbook. It will update as you add or delete sheets, or change workbooks. It is particularly useful in large workbooks.
The addin is designed so that it will work in any workbook that you activate, immediately updating to show that workbook's sheets.
Install the addin
The zipped file
contains the addin & an installer workbook. It is now self installing.
Simply extract the file to a suitable folder o your hard drive, double click the
navigator(v1.04).xla. The addin will open & ask if you want to install as an
Excel addin, 
You will
receive success message when the installation is complete
New Features:
1. There is now a Button to allow you to browse for workbook(s)
to open
2. A new dropdown lists all open Workbooks and allows you to
quickly activate a different open WorkBook.
3. A new button will have been added to the top of the File menu
enabling you to quickly access the
Navigator Toolbar.
Click here to Download
AddTOC - Table of Contents
This addin can be used to quickly & simply add a Table of Contents page to any Workbook. It will also add hyperlinks to the Worksheets. The zip file contains the addin and a workbook that can be used to automate the correct installation of this addin.
Click here to Download