Automate Excel Audit Sheet to create a Data File

Hi,

I am currently audit my team for the calls that they make to our clients.

I wish to automate the audit sheet so that all the data on the sheet is captured to another sheet.

Currently, I create a new sheet for each audit which is time consuming and makes things difficult for collating the data.

I am looking to have a 'Submit' and a 'Clear Form' button to my sheet so that I can audit using the same sheet for all the calls and capture the data for each audit on a separate sheet.

I have attached a sample audit sheet of mine for better understanding.

How can I go about it?

Thanks!