Data entry form to populate certain table dependent on validation list

Refer to the attached. So as per the code now, once you input the SMU in F7 on Data Entry Tab, the form data is transferred to the Tables Tab in the relevant Table. That's the only way you can use the Enter key to submit the form data.
You can delete the button if not required.