How to move first row from Sheet1 to Sheet2, move second row on Sheet1 to Sheet3, move third row on Sheet1 to Sheet4 then repeat?

Question

I have a list of data about 20k rows long and all data is in the first column. Each record has three rows of unique data.

I'm trying to move each row to a new sheet and repeat until the end of the workbook.

EX: Move first row from Sheet1 to Sheet2, move second row on Sheet1 to Sheet3, move third row on Sheet1 to Sheet4.

I've tired some variations of offset and index formulas.

Answer 1

The basic formula will be:

=INDEX(A:A,(ROW(1:1)-1)*3+1)

Where the *3 is the number of rows of unique data and the +1 is the start row. So on the first sheet it will be +1, +2 for the next sheet and so on.

Copy over and down each sheet.