How can I automate the duplication of a row when the use tabs out of the last cell?

I'm trying to duplicate the Access "Add Record" functionality in Excel. I want to put this basic record keeper at an operator's workstation so the he/she will record QC results. This will allow us to collect the same data in the same format across multiple workcenters for later collation and analysis. And no, I can't use Access, as much as I would like to. I know how to lock the cells not in use, but how do I create the next record; how to "freeze" the timestamp (Col A); and how to duplicate the dropdown references in Cols. B:E,N

Is there any way to do this in Excel?

Thank you! I do a lot of data manipulation with excel, but I haven't done much development for other users. I didn't even know this was a thing. This is such a small little doodad, it should be easy.

I appreciate your help,

Alan