Office 365 Excel Help

Cycle Name Partner Job Pet Week Salary Super Award
1 1LoneWolf Wilma Laundry Wolves 5 $3 Johnson 4
2 2Couple Betty Shop Pigs 4 $7 McCoy 5
3 3Tra'ys Thelma Cook Ducks 6 $4 Bismark 3
4 4Hommer Louise Dance Chickens 4 $2 Peterson 6

Sheet = Example Range = A2:I2, A3:I3, A4:I4, A5:I5 each row independent in table

I want to copy - any row selected and Paste it to Sheet#, where # = Value in Column I

I.e. Selected Range = A3:I3 (2, "2 Couple","Betty","Shop","Pigs",4,7,"McCoy",5)
and paste to next available row on Sheet5