I need a formula that says something to the effect of:

IF the value in H=1 THEN transfer said row to sheet 2
IF the value in H=2 THEN transfer said row to sheet 3
etc.

I need all the information in the row to transfer, and have no idea how to
do it.