Input Form to Get Data and Store it in Another Tab in Excel

In the macro, after the lines that transfer the values to the other sheet, put something like this for each field that you want to clear:

Worksheets("Input").Range("F3").Value=""

Change Input to the name of the sheet with the input form and F3 to the range address of the field to clear. Just put this line as many times as you need to clear all of the fields.

It's not likely to be a good idea to delete anything. Instead, ceate a way by which you can tell if an entry has already been made. In the case of a salary that would be the month, or perhaps a date. Then, when the user presses the Submit button the code looks for that entry and creates a new one only if it isn't found. If the user presses Submit repeatedly you get the choice of either over-writing the existing or refusing to make any entry or perhaps giving a message and ask the user for a decision.

This choice is a matter of system design. If you do allow over-write the user could make changes to the original data and thereby change the previous entry. Either way, both records would stay synched.