We are trying to produce a summary sheet that displays the value of the same
cell from a range of sheets. Ideally it will be a formula that can be copied
down the column, with each cell incrementing to the next sheet.
possible solutions might be around the use of a reference list to change the
sheet reference within the formula?apologies if this makes no sense! happy to
elaborate further