VBA code not replacing existing data?

Good day all once again,

I am working with a VBA Code that pastes the inputted data into 2 sheets, one for keeping records of all inputs & another that paste the data to the same Row "A" each time, the latter being used to populate my list, however when I re enter a second set of data I get the error code "Run-time error 1004" "PasteSpecial method of Range class failed" & not sure why this happens when the code I am using works perfectly in another worksheet? Thanks in advance for any advice & have a great day - Marco

how can I test it ?