=INDIRECT(A2&"!A1")

HTH
--
AP

"David Boothe" <not@onyourlife.net> a écrit dans le message de news:
MPG.1ee33a1f877004cf9896aa@newsgroups.comcast.net...
>I want to do something like this...
>
> 1st worksheet name "targetTab"
> 2nd worksheet name "sourceTabA"
> 3rd worksheet name "sourceTabB"
>
>
>
> In cell A1 of the sourceTabA worksheet is "APPLES"
> In cell A1 of the sourceTabB worksheet is "BANANAS"
>
> I want a formula to put in cell A1 of the targetTab worksheet so that
> when I enter "sourceTabA" in cell A2 of the worksheet the formula
> returns "APPLES" then when I enter "sourceTabB" in cell A2 the formula
> returns "BANANAS".
>
> Can someone help me with this please?
>
>
> Thanks!