Need to move row to a new worksheet based on the date in a particular column

[MDNerey]

Hello,
I am new to VBA and Macros. I am working on a Master worksheet at work where we will input data and then link it to other worksheets that need to be created (so we aren't entering the same data multiple times). It houses all of the ongoing projects. We have an 'archive' worksheet next to the main worksheet, and I would like the data from row(s) to move to the archive worksheet if the date in the End Date column is anything before today's date (today's date being whatever date the worksheet is opened). I would also like it to run this macro automatically every time the worksheet is opened in the morning.

Thanks so much ahead of time for your help and patience!!

[MDNerey]

Good morning,
I know there is a way to do this, I just don't know enough about programming yet to execute it. Basically, if the date in column 'AM' is before today's date (>TODAY()-1)???? I want that whole row of data (Row x, A:AU) to move from the "InLife-Upcoming" worksheet to the "Archive" worksheet automatically when the workbook is opened each morning.

Thank you so much!

[MDNerey]

Anyone...?

PLEASE?!?!