Hi,

I have several worksheets with exactly the same layout on each, and a summary sheet.

The summary sheet needs to show cell A47, B47 & J47 from each sheet.

Obviously I can type = and then go to cell A47 in the first worksheet, and then the same process for B47 and J47, and then do the whole thing again for the next worksheet, but this is very time consuming.

Is there a formula that will select cell A47 in the first worksheet, which I can then copy down and it will select the same cell (A47) in the next consecutive worksheet, and so on?

I have searched google etc and keep coming up with =INDIRECT, but don't know if this is right and can't get it to work.

Thank you for you help