Help! : How to copy row into another tab if value in “C4” matches value “PB”

[Animalised]

I am using VBA for excel and not having success in creating a macro that suits my needs. I'm trying to create a macro that can be run on the Active X Control Button. I'm trying to do this: If Cell "C4" has employee code "PB" then I want to copy that line of text and paste it onto another tab named "Patrick Brenn".
I also want for the macro to compile a list in that separate tab, named "Patrick Brenn" (which is why the Employee code is "PB"), in a way that doesn't delete the previous pasted entry.
When the data has been copied over, I'm looking (with no success currently) to change the "PB" Value to "PB1", then "PB2", and then "PB3" each time information is pasted into.
Does anyone know how to do this as I am completely new to this and am very stuck! Thank-you for any help you are able to provide!
(p.s. I can show you my macro but its a mess and doesn't work; ive tried to mash a few macros together and adjust them to my particular needs with, again, no success).
Thank you in advance if you're able to help in this matter!

 

[Leotaxi]

Sub test()If Range("C4") = "PB" Then Range("C4").EntireRow.Copy Sheets("Patrick Brenn").Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub

Kind regards
Leo

 

[Animalised]

Thank you Leo for the help, its much appreciated and has helped me to understand this better!

Good night!