Copy multiple rows of a given criteria then find next.

So far, i've coded to copy the first row. But i want to copy the rows before another name comes up. Like in the exam, i want to copy all the rows under the first "Leo Valdez" then move to the second one then copy it again.

Any help?

I was able to solve it by myself already.