Find text and open hyperlink
 

I have a spreadsheet with about 30 worksheets in it. I use the first page as
a "directory" where the names of the worksheets are listed. Each name of the
worksheet has a hyperlink to take the user to the appropriate worksheet. The
sheets on the directory are in a particular (but not alphabetic) order.

I would like to have a combo box (unless there is a better suggestion) where
I could do a quick search. I would like for it to auto complete what I type
in and then go to the correct worksheet. Any suggestions?

Thanks for any help!