Creating and Index with worksheet names
 

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?

Creating and Index with worksheet names
 

See

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

In article ,
"JackR" 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?