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!

 

Joe 

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?