linking cells by formula

[smuggler]

Hi, I have a master wks with many identically formatted wks each named after different countries.

I would like to put a formula in B1 of my master sheet that will pickup info from H6 of the country wks listed in A1 of my master sheet. If that can be achieved, all I would need is to to copy B1 to the cells below to produce a quick result for all my wks.

	A	B
1	Australia	?
2	USA

<tbody>
</tbody>

 

[Rick Rothstein]

This formula should work for you...

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

 

[smuggler]

Rick, thank you so much for giving of your time to help such a novice as myself. I really appreciate it... and I'm sure many others do too.