I have data on one sheet (Data) that I am pulling from to fill my second sheet (Results).

My Data is listed 1-100 on the rows (for example).

However, on my Results sheet, each page is just for one row on the previous sheet (with a bunch of other data involved from the columns).

When I try to copy/paste the Results page to make a second sheet, I want to be able to use from Data!A2. Instead, it gives me Data!A63 since the entire page is 62 rows.

Is there a macro that I can use to make the copy/paste go to the next number in the sequence from the Data sheet instead of trying to equate how many spots I went down on the Result sheet?