Vlookup for Tabs

[metfast]

Hi All My question is in my workbook i have 105 Tabs the first five are used for other things, Now is their a formula/VBA similar to a vlookup where i can put the sheet No/Tab into and then go strait to the tab/sheet and if possible open the Tab/sheet. Al the Tabs/Sheet have a number (example: 10421) So i'm looking for a vlookup or find formula so as when i put the Tab/sheet No in it goes to or even better opens this up.
hope i have explained ok, i have looked on here and googled but no luck yet.
Regards Ge Perth Western Australia.

 

[mart37]

A1: 10421
B1: =HYPERLINK(CELL("address",INDIRECT("'"&A1&"'!A1")),"GOTO")

 

[metfast]

Thanks Mart37: i will give it a try and get back to you in on Sunday or Monday.
My time zone GMT+8hrs
Ge Western Australia

 

[metfast]

A1: 10421
B1: =HYPERLINK(CELL("address",INDIRECT("'"&A1&"'!A1")),"GOTO")

Mart37: Sorry mate its not working tells me there is an error and highlites the GOTO, i then accept the suggestive correction to that it produces "REF" in B1

 

[mart37]

I see that a sheet name with a number don't work. With a doubleclick on #REF I can jump to the sheet.

 

[Fluff]

How about

=HYPERLINK("#"&CELL("address",INDIRECT("'"&A1&"'!A1")),"GOTO")

 

[mart37]

=HYPERLINK("#"&CELL("Address",INDIRECT("'"&A1&"'!A1")),"GOTO")

 

[metfast]

Thank you Guys or Gals ?, This works a treat.
Well Done Thanks.
Regards Ge Western Australia. GMT+8hrs.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[metfast]

Thanks to all, as i said it works a treat but what happens if i actually want to put the data in D4.
Do i just change the A1 in your above formula to D4 ?
Thank you