Add new record to database

I am not an excel expert and I found many of the items that are in my spreadsheet in others and changed some things to fit my needs. Attached is one of my agreement packages that has the issue. The major issue or problem I'm having is on the input tab. When you add a new record, this is accomplished by entering a new CustomerID thats not in the CustomerData worksheet and pushing the add button, this creates a new customer record in the CustomerData sheet but it copies all the previous records data! I need it to create this new record in the CustomerData worksheet and all the grey cells need to be blank.

Can anyone help me with this?

My apologies if this is posted in the wrong area and thanks in advance for any and all help!