VBA code to paste to a new row in the same column ???

Hi

i would greatly appreciate your help with this.

i am setting up a macro to copy names from a column in each of three tables and then paste them all together in one column in the same worksheet.

i have attached my worksheet.

so i want to be able to copy from cell A3 all the way down to end of col A, and paste that to S3.

And then ALSO

copy from cell G3 down to the end ( or it can be from G2 to include the NAME title if its easier ) .

but the thing i am struggling with is now to paste it to the bottom of the column S ( that already has the pasted data that was done earlier ).

so in effect i would have a macro that copies all names in the tables ( no other data from tables required ), and pastes those names into column s. ( to look like column y )

really hope someone can help with this and is very much appreciated

many many thanks

steve r.