excel functions

=MOD(ROW()+E2,5)+1

MOD returns the remainder after one number is divided by another

Row() returns the number of the row the formula is in

Therefore, this formula adds to the current row number the value in cell E2, this sum is then divided by 5 and 1 is added to the remainer of this division.

Example. Cell E2 contains "7" and this formula is entered in Cell B6. The result is:

6 (the row number of the formula)+7 =13, divided by 5 has a remainder of 3, plus 1 returns "4" in cell B6

HTH