Populate new row in table from a form (not userform) on another worksheet

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.

Attempted to upload file on 2 browsers (IE and Opera) without success. Not sure if you can help me with this situation.

To answer the question, I'd like for the VBA to make sure that all mandatory fields are filled in prior to submission (copying and pasting) to the 'Data' table on another worksheet.

I've attached screen shots of the 2 worksheets so you can get an idea of the format. If you have any input on how to attach the file, please let me know and I will upload right away.

Thank you.

Sorry, forgot the attachments:

Data Worksheet.JPGInput worksheet.JPG

Oh, sorry. Didn't realize there was a section below for attachments (new to this). Please see the workbook. Thank you.

E3:e13, e28

Column A was going to be used as a lookup tool so it's not part of the initial data entry. Eventually, I was going to add in a VLOOKUP Function to search if there was a previous identical entry.

Columns D, G, and J are headers in the table 'tblData'.

Do the fields in the Input sheet need to be consecutively ordered as they appear horizontally in the Data sheet? I.e. ReferralID followed by PID, followed by CDCR#, etc., or there just needs to be a match for every field on each sheet regardless of position or relation to each other?

Again, thanks so much for taking the time to assist me. I am working on the edits now.

Does there need to be a match on the Input sheet for every column in the Data sheet, or will the code run on just those fields where there is a match? Sorry for the additional questions, just want to make the best use of your time.

See attached. Confirmed all fields on Input sheet are identical to column headers on Data sheet. Thank you.

Mumps1, Thank you so much! I have spent hours trying to find this solution and you were able to provide it quickly and completely! Again, thank you.