Using worksheet name as reference

[ssuryarao]

HI

I have one master sheet with around 50 rows in it. For each Row there
is corrosponding worksheet. e.g. Row #23 will have corrosponding
worksheet named '23'. I want to populate some data from worksheet 23 in
Row no. 23 in master sheet. How should I refer the sheet 23
automatically using Data 23 in cell in the row ? If type ='23'!B21 I
can get it but I want to automate it so I'm refering to cell instead of
23 which is ='A12'!B21 here it gives error because I'm making formating
error.
Pl. help .
thanks.

 

[KL]

Hi,

Try this:

=INDIRECT("'"&ROW()&"'!B21")

Regards,
KL

 

[ssuryarao]

Thanks KL for quick clue !
Instead of RoW() I used column .. That really helped. Thanks a lot !