I'm trying to create a form for work whereby the user can input data into it, then press a submit button which will send the data to a separate workbook for analysis.

For example, the sheet will ask:

Their name
Date
Customer Name
Advisor Name
Date of Transaction
Etc
Comments box.

I want users to be able to input the data into specific fields and then just click submit and away it goes. I have very basic knowledge of Excel.