Display data from central sheet on multiple sheets

Occasional Visitor

Hi there, 


When creating a new sheet to display the results, i want all formulas to pluck data from one row down on the central sheet. 


Sheet attached. 


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?


Any help much appreciated!



1 Reply
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?