Easy data entry into Table

As you are already using macros/VBA why not use a bespoke UserForm (note this is not the in-built form) but a facility within the VBA editor - far more logical than entering manually to the sheet.

Look back on this site in the next couple of days I will put something together that will hopefully be a guide.

The attached file is just a basic framework of a userform to demonstrate the handling of your data to/from the sheet.
The sheet is using a 'structured table' to contain the data (there are no formula or data validation on the sheet - these would be taken care of as the code is developed).
Just a few basic things to bear in mind - do not extend tables with a multitude of blank rows - 'structured tables' are intended to be dynamic (i.e.) they will expand/contract automatically on the addition/deletion of data.
Do not place tables under each other or adjacent each other (without knowing future expansion) as they will amalgamate if the separation is closed as the table expands (causing frustrating troubleshooting).
I have only put one selection combobox in place at position 8 (I could not relate some of the others to your intended use)(these replace the data validations of your original sheet).
To work with minimal code I leave controls (labels,textboxes etc.,) with their default names - this allows then the use of of a basic loop to iterate through them instead of individually naming all 25 (saves acres of code on a big app.)
You will see a textbox overlaying each combobox this is held in focus by the ZOrder - assists the above looping and use of the form for all actions - see first combobox is also a means of search for data to update or delete.
Lastly to add additional data first press 'CLEAR' - this ensures form is blank and activate 'ADD' button - enter your data then press 'ADD' this should transfer data to the table.
Post back on this site if you need further help.