All I'm after doing is:-

From a click of a button

Copying in formation from a form in excel to a table in excel (same
workbook)

Clearing data in form (reset form to blank)

then next time the information is populated in to form it will add this to
the next line in the table

Cheers