I have an excel worksheet with over 50 sheets, each sheet contains a lot
number in cell B7 which is also the name of the sheet. Is there a way to
make the first sheet where you type in lot #G0116 for example and the user is
"hyperlinked" to that sheet?

Any help wuld be appreciated~