When creating a new sheet to display the results, i want all formulas to pluck data from one row down on the central sheet.
Difficult to describe, but basically results sheet number 2 needs to read results from one column down than what results sheet 1 does. What is the best way of doing this please without altering every formula?
Why not have just one dashboard sheet which uses the INDEX function to get the data from the table using a helper cell near the top of the dashboard in which you can e.g. enter the row number to retrieve?