Scroll right down to the bottom of the page for the download link:
XL Extras - release 1.19 ... Download
A collection of additional features including...
**create table of contents with hyperlinks to each sheet
Jim's add-in will do exactly what you're looking for (and much more ..)
After installing, just click Insert > Table of Contents, then sit back
and watch Jim's magic go to work <g> !
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.