Populate new row in table from a form (not userform) on another worksheet

Could you attach a copy of your file and explain in detail what you mean by

Confirm completion of all mandatory fields (with error notice if not complete)