Data Input Form

[howey9]

Hey guys

I’m looking for a macro or VBA code to take data from my input screen to my data table. What I am aiming for is the data input screen to just take the few bits of info I need for each record and then when completed and hit enter it moves to the data table and leaves me with a blank input section once again.

Any help greatly appreciated. Workbook attached

Thanks