In the past, I've used various "Table of Contents" add-ins that create
a new worksheet with a clickable link to all the tabs within the
workbook. I quickly did a search and found this one:

http://www.tushar-mehta.com/excel/so...Help/toc10.htm

Although I've never used it before, I'm sure its fairly similar to
what I've used in the past. I don't know if this is what you're asking
about, but it does give you a view of all the tabs in the workbook,
and easier navigation.