Autofill and open worksheet

I was hoping to use a cell that as I typed would begin to populate whatever tabs began with the letters I was typing. Maybe something like a search box that when selected would open the worksheet. I think I have close to 100 worksheets that I need to access weekly and scrolling down on the tab arrows takes a bit of time. I started messing around in excel and love the possibilities but such a newbie I could use some direction. Thank you for any input and help. sippin

To search External Files from a cell isn't going to be discussed here! That is WAY beyond the scope of this forum! It becomes cumbersome to hook into the filesystem, and would be way to tough to explain all of the different scenarios to make your solutions bullet proof! Are the files on your local computer, or on a share?

It is for work. Thank you for getting back to me so quickly. I can just use the hyperlink option and call it good until I get much more stick time in excel. Again thanks!

I encourage you to possibly use a built in search on the Operating system, it is already in the can and working as a search!