copying row to top of another sheet via automation
I have an automation in place that copies a row from one sheet to a secondary sheet but adds it to the bottom. As we're using this for a new hire process, I'd like the row to be added to the top of the sheet when copied. I have a column that records the time and date the submission was made and tried sorting on that column. It works as long as I'm on that sheet but if I leave and come back, I have to resort. Does anyone have a solution or a suggestion?