Creating and Index with worksheet names

[JackR]

I have a workbook with about 40 worksheets, I would like to create 1
worksheet that woud provide the user with a list of all the worksheets, and
then be able to click on that name and have it take them to that worksheet.
sort of a control panel that they can go to to find the sheet they are
looking for instead of going through all the tabs.

Any easy thought on how to do this?

[JE McGimpsey]

See

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

In article <[email protected]>,
"JackR" <[email protected]> wrote:

> I have a workbook with about 40 worksheets, I would like to create 1
> worksheet that woud provide the user with a list of all the worksheets, and
> then be able to click on that name and have it take them to that worksheet.
> sort of a control panel that they can go to to find the sheet they are
> looking for instead of going through all the tabs.
>
> Any easy thought on how to do this?