I would do this in a "form". That way you could make sure the data is
there and not put it in the sheet if fields aren't filled in. You
could also password protect the real sheet so that they can only enter
data via the form.

If you need more please let me know.