I just need it to be pasting into the first empty cell in that column. I recorded a macro and it used this method
Range("C4").Select
    Selection.Copy
I'm not sure how to tell it in my code to select whatever cell it is currently on in the loop...