I am starting a research project and was looking for the best way of keeping track of the data. Is it possible to have a group of cells where i can enter the data on a main sheet then have a submit button and it puts the data on another worksheet? I wanna make it so that people don't accidentally change data while imputing new data.
Data that will be entered is a

Im trying to find a correlation between two disease in dogs.
Reference number:
Name:
Sex:
Breed:
....
And a place to put any additional notes

Thanks