Hi all, I have written a workbook with some 40 worksheets in it to be used as a reference database. Each of the 40 worksheets has a specific name (tab). Is there a program/formula that I can put on the very first page so that a user can input the name of the sheet/tab they want and that sheet will open for them. Basically to stop them having to sift through 40 tabs to find which sheet they need.
Thanks
Kev