Basic copy paste macro not working

[geeman86]

Hello,

referring to the spreadsheet attached. I am inputting basic data in column C3:C9, and outputting that data in row B14:F14.
I tried to create a macro that once I hit copy paste values (I want to copy paste special i.e. values), I want to copy the output data into a new row.

Then as I change the inputs, employee name, hourly rate etc, the table output will update, so then I want to then hit the copy paste values macro to then paste the new information in another row below the previously pasted data.

Hope that makes sense, thanks in advance.
-G