How do I change +Sheet1!XY for each sheet?

[Closed]
Report
Posts
2
Registration date
Thursday May 18, 2017
Status
Member
Last seen
May 18, 2017
-
Hi,

I've been using +Sheet1!XY to copy data from one sheet to another, from the same row in Sheet1 - row 8

On the next sheet I need to to copy the data from row 9, and so on. How do I easily do this change in the +Sheet1!XY formula without having to manually edit the row number?