Hello,
I am looking for a way to take 18 different workbooks, each containing the same 5 worksheets, and create a TOC that reference the workbook name only.

For Example, I would like to have one workbook with the first worksheet as an index or a table of contents that lists the name of 18 workbooks. When I hover my cursor over the name of a particular workbook in the index or TOC, it will open that workbook where I can now view 5 worksheets of that workbook.

Note: Each workbook will contain the same 5 worksheets.

I am using excel 2002

Thanks in advance