Copy rows of data to new worksheet based on cell value in another

[Carlab49]

Hi All,

I've been reading through previous threads, but just cant get my head round the code required to do the above.
I would like to auto (Copy) populate the row data to another worksheet based on certain criteria entered into a column on another.

I have attached a copy for reference.
On sheet 1 (AFQ) i am using columns A - J. I would like to copy the row data of the same columns on sheet 2 (PAWEL), if that name has been entered in column H of sheet 1 (AFQ). Then to do the same for sheet 3 (PAUL).

Then i would like to do the same for Sheet 4 (Complete), but this will be based on "Complete" being selected in column F of sheet 1

Can some provide some guidance on this please, would be very much appreciated.