I am looking for method of linking the cells of various cells from various
sheets I formatted identically.
A1 B1 C1 D1
E1 F1
='sheet2'!$A$1 ='sheet2'!$B$1 ='sheet2'!$C$1 =sheet2'!$D$1
='sheet2'!$E$1 ='sheet2'!$F$1
='sheet3'!$A$1 ='sheet3'!$B$1 ='sheet3'!$C$1 ='sheet3'!$E$1
='sheet3'!$E$1 ='sheet3'!$F$1
and so on... if I drag the cell A1 which is ='sheet2'!$A$1 to A2 then the
cell A2 should give the result ='sheet3'!$A$1

I tried by dragging down the linked cells of A1 but it does not link to
sheet2 and so on . How to get that done without macro?