I need an index file containing the names of all the worksheets in a workbook.
I keep an Excel workbook for recipes..... a lot of recipes; each worksheet is for a different recipe. Is there a way to keep some kind of index worksheet for the names of all the different worksheets? Maybe if I could go to the index file, create a new name and a new worksheet would be created with that name? The alternative is to create a new worksheet and manually enter the name of each worksheet, then scroll through the workbook to find the sheet I want. Ideally I could go to the index, click on it and go to that worksheet. Possible?
|