One way:

=INDIRECT("'"&$A$1&"'!B"&ROW(A15))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"GregR" wrote in message
oups.com...
Same questions, but get B15 to increment as it is filled down. TIA

Greg