I have a worksheet called 'Input' where the user enters data in various staggered fields (not in a table format). I want that data added as a new record (row) to another worksheet 'Data' that is a defined table. I've found various websites/posts that can add a row of data to another worksheet, but not VBA that will copy and paste new data from 1 worksheet in a non-table format to another worksheet that is in a table format. I would like to do this without a userform and maintain the Input worksheet for data entry.

So, basically I need this series of actions to be completed:
1. User enters data on the worksheet 'Input' form and clicks on a button Submit (also a button to Cancel), 2. Confirm completion of all mandatory fields (with error notice if not complete), 3. copy and paste the new data into the worksheet 'Data' by adding a new row to the existing named table 'tblData', 4. Clear the 'Input' worksheet fields for the next record entry. Any assistance would be greatly appreciated.