dynamic build

[shank]

='UNITED ARAB'!$B$4
UNITED ARAB is in column A2 of present worksheet.

How do I build a formula to concatenate A2 into: ='UNITED ARAB'!$B$4
Should look something like: =A2+!$B$4
But my syntax is messed up.

thanks

 

[Bob Phillips]

Try

=INDIRECT("'"&A2&"'!B4")