Using command button to copy cell contents and paste to different sheet, then clear cells

Afternoon all,

I am looking to utilize some VBA assigned to a command button that will in essence copy the contents numerous cells in sheet 1 and paste them into specific rows in sheet 2.

Sheet 1 is essentially a 'Data Entry' form, sheet 2 is a 'Master' sheet containing all data entered historically. For example, the command would copy the contents of cell A1 in sheet 1 and paste it to the next available cell in column A of sheet 2. Once all relevant cells were copied to their corresponding columns in sheet 2 all relevant sheet 1 cells should be cleared ready for the next data entry.

Unfortunately i do not have a finished example sheet currently but these are some of the cells that would require copying (along with their assigned paste rows)

X4 to Sheet2!G:G
X5 to Sheet2!C:C
X6 to Sheet2!D:D
X7 to Sheet2!E:E
X8 to Sheet2!F:F
E24 to Sheet2!L:L
O24 to Sheet2!M:M

etc...etc (there are a few more which hopefully I would be able to figure out how to add once the code structure is in place)

Any help on this would be greatly appreciated.
I'm aware it may seem like a somewhat easy request, the thing that is stumping me most in the next available row part.

Thank you in advance,
Regards

Ethanrholt

I seem to have managed to get it working. Thanks for your assistance Greg.

much appreicated