Tab lookup

[bend01]

Hi,

I know there is a HLookup & VLookup function (which i am not very famialir with) but I wondered if there was a way of looking up the name of a tab. For example:

If the tab name is UK then Sum A47 on that sheet.

Thank you in advance for your help - I'm sure this is possible as everything else seems to be on excel, its just knowing how...

 

[NBVC]

If the tab name is located in say, cell A1, then

=INDIRECT("'"&A1&"'!A47")

 

[bend01]

Thank you so much for getting abck to me so quickly.

Hopefully you have just saved me an hours work!