Managing Items on Multiple Lists

I am tracking estimated costs of facility upgrades (Sample spreadsheet attached).

There is a data entry tab where all of the costs are entered and then logged into the individual tables (UnitCost_TBL, UnitsTotal_TBL, LaborCost_TBL, LaborHRs_TBL, Total_TBL)

I need the option to add products on the data entry tab. To add the new product to the data entry tab alone I’m using the following:

Please Login or Register  to view this content.

BUT, I have not added the product to the other tables. I am looking for ideas on a better way to add/remove products from the data entry tab and all of the tables.

I am able to duplicate the above code 6-times but that seems inefficient and long!

I do not know how to make this work easier but I'm confident that there is a better way of adding the same product to all of the lists on each sheet without listing the above code 6 additional times! Ideally I should be able to address adding or removing product from the list in a similar manner. However, adding product is much more of a priority.

Any advice would be greatly appreciated!
Thanks!