I have data stored in multiple worksheets with identical layout (eg reference
no is always in cell B2 for every sheet).
I would like to summarise selected data onto a single sheet with the data
presented in rows.
I would like to insert data from sheet 2!B2 into sheet 1!B2 and then from
sheet 3!B2 to sheet 1!B3 etc.
I can create link from sheet 2 to sheet 1 but if I try to copy the link
formua down, it links sheet 1!B3 to sheet 2!B3 and not sheet 3.
Can I make the link reference jump to the next sheet each time?
is this possible?

Martin McLaughlin