VBA that copies values to bottom of other sheet

Hi All,

I tried looking for versions of my request online, but do not understand VBA well enough to alter what I found to what I need. Here's what I am looking for:
- On sheet one I have created a faux form with about 10 fields (because of who will be using this file, I cannot use a UserForm).
- I would like a macro that, if all the fields are filled, will copy the entered values and paste to the first available row of sheet two.
- along with the values from the form, a timestamp value would also be helpful.
- the macro will clear all but the first two fields once the values are pasted.

If it helps, the "form fields" are (let me know if the data formats matter):

1. month/year
2. area
3. facility
4. grade
5. return rate
6. customer count
7. volume rate
8. daily report
9. employee ratio
10. quarterly meeting

Thanks for the help on this!
AA

.
If you are looking to improve and learn how ... here is an excellent resource that explains (step by step) precisely what you are seeking plus
it provides a workbook download for examination :

https://www.exceltip.com/vba/update-...rough-vba.html