Hello
I need to create a form for employees to complete, print and save in the
computer.
This form will be in a common drive so all employees have access to the form.
After the form is completed, the employee will €œsave as€� the form with a new
name in the common drive
Next employee will use the same form €¦

For my records, I need to have all the information in the form in an excel
file . Not a copy of the form, just a file with the data.

Lets say at the end of the month 30 people completed the form I should
have an excel sheet with the data of the 30 forms.

Not sure how to do this?
Do I need two worksheets, one with the form, one hidden with the data in the
form?
How do I get the data from the form to the other spreadsheet?

Is there a book or a site that can help me with this? Thanks in advance