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...