Need Help Optimizing Code

For the past week I have been hard at work basically learning VBA and macros and such for a project at work. My efforts , to my surprise, have been quite fruitful. Though I cant help but think my code is sloppy and could likely be optimized to run faster but I do know the first thing to look for since I've only learn how to do everything here in one particular way, also I'm deathly afraid of changing anything at this point and bringing it all crashing down. Could some of you excel masters have a look-see at my script and let me know if there is room for improvement

The file works like this:
-operator opens file and if new a part is being produces he goes into the Tool List sheet and populates it to the best of his ability (in reality only column A with the numbers is required)
-when the operator has to replace a tool in the machine he does so, then goes into the excel file and under the Input sheet types the "tool number", "work order", "running total of parts" and "notes"
-clicking the "add" button enters this information into a table in the Tool Data sheet from which the pivot table and chart pulls from and updates the descriptive statistics.

the whole point on this is to give the operator a feel for how long the tools in his machine are lasting during a particular work order

I have attached the file for you feedback along with some sample data already put in.

When I read the word 'operator' it probably means a few people will be working with this file.
Giving them access to your sheets directly is a dangerous game you're playing because at some point they'll start messing around to correct an error they typed or ... ending up destroying your entire file.
You will have to protect your sheets thouroughly so they don't get access where they shouldn't (just to protect your formulas and such) or have a look at building Userforms so direct access isn't needed.

Select the cells they need to fill. Right click and select Properties. Select tab Protection and unlock these cells.
Now protect your worksheet so they can only select unlocked cells.