change formula to copy data from different sheets

[redspanna]

In Sheet 'Summary' I have this simple formula in cell B2

='1'!$K$2

how can this be slightly changed so that it will automatically change when copied to cell B3 to take the value from sheet2 cell K2, then also change when added to B4 so that it takes the cell value of K2 in sheet3 etc etc

so to end up with the following formula in each cell...

B2 ='1'!$K$2
B3 ='2'!$K$2
B3 ='3'!$K$2
B4 ='4'!$K$2

etc etc

thanks in advance

 

[philwojo]

woops I misread your post, sorry, at work, disregard this post.

 

[philwojo]

Try this, put it in B2 and copy down.

=INDIRECT(CONCATENATE("'",ROW(A2)-1,"'!$K$2"),TRUE)

 

[redspanna]

Thank you