Populate spreadsheet / log with data captured from from

[swaldron]

Good morning,

Forgive me in advance if I am posting in the wrong place, but I'm new to the forum and am attempting to find my way through the site. I have created a "form" on the first page of my spreadsheet and am wanting to use the information captured / submitted in this form to populate a spreadsheet / log of sorts on another page within the workbook. I've never used templates in Excel, but realize that I may need to convert this document. (Advice on this would be helpful as well.)

The form is set up so that the date of the form will auto-populate and some of the fields are drop down selections and other require dates or text. The form can be submitted via e-mail by pressing a button located on the form.

What I want it to do is:
A) Capture the data entered in the form on a separate spreadsheet with columns titled the same as the fields on the form (separate sheet already set up with the workbook - need formulas or code to execute data capture)
B) Submit the form via e-mail when the button is pressed (which I've already done)
C) Clear out /reset the form once the information has been e-mailed and the data captured on the spreadsheet

So, this form will be used to submit reports to those it will be e-mailed to, then a running log will be created by the data captured on the form on a separate sheet within the same workbook for those submitting the form to manage.