Need a macro to move row to new sheet based on cell input

I have an excel file that i have created with a cell with the IF statement. It is for contracts and I have the contract start date, length and expiration. I have excel check the expiration date with the current date using the TODAY function. If it is expired, the IF gives a "yes" in column F. I would like a macro that will move the row that contains the expired contract to the "Expired" sheet. I have gotten macros to work, but none of them automatically run for when the document is automatically opened with a macro that I wrote that opens the file, allows it to update and saves it. The cell in column F will change to "yes", but nothing will happen. To get it to work, I have to go in and manually press enter in the cell to get it to recognize that it has changed. What do I need to add to allow it to check for the "yes" automatically and updating without my input of the cell.

Thank you

I have attached my excel file. This is for a contracts, and I have written a program to open, allow it to update to the current date and save the file, and schedule this to run everyday with Task Scheduler. It also sends an email when a contract is near expiration (within 30 days), but right now I have it just display the email to avoid unnecessary emails. Now, I need a macro to move an expired contract from the Customers tab to the Expired tab. I have one that does that, but it only works when the cell is clicked on and entered. It does not change when the date changes which causes the IF statement to display the "yes" value in Column F which is the trigger for my macro. Test 2 and 3 are expired and have moved tabs, but not automatically so that is what I would like.I need a way so that it will automatically trigger it when the date changes so I do not have to be involved with the move. Try it out by changing the length of the contract to a length that will cause it to be expired and it will not move, but once you click on the correct cell in Column F and press enter it will move. I would like a way to make this all automated and I know I am close, but am just missing one or two lines of code.

Thank you

I added this to Customer/Sheet 1 and cannot get it to work. When it does cut and paste a row, it is the wrong row and is always the bottom two or three rows. I cannot seem to figure what the error is. Any help is appreciated. Thank you

Here is the code that I have inserted in my file. Nothing seems to happen when a contract expires. Thank you for working with me and being patient, I really appreciate it.

I change the length to one year so that it has expired and nothing happens. I also reset my event handler. Still nothing happens

When I add change the email address in E2, it moves a bunch of my rows over to expired and I am not sure why that happens

Yes, I meant E3, that was a typo. I'll give that a try, thank you

That code you have to go over cell E2 and hit enter to get it to register.