Match Column A's Project number to change based on greater number in new row

Here is my Workbook and as detailed instructions as possible. (I have deleted the rest of my sheets)

Match.xlsm

On open you will see that Column "A" will all have the same project number and also Column "M" (Column "N" becomes my new search from sheet to sheet but that is my in house process)

If you double click a project number a user form will generate I have disable "Delivery Complete" therefore Select "Options"

In "Options" select "Termination"

In this user form a set of questions will be asked...

First one Select "Yes"
Second is a Combo box select Anything it doesn't matter
Third question Select "Yes"

In this User Form fill up the textbox and make sure you select the Checkbox at the end then Select "Add"

You will see that my old number (001) from column "N" will be transferred to my Archive sheet and a new row has been inserted with Contract number /005/HS and Column "M" is 005 but all the rest is 004.

I need that every time I make this code (My termination) it will look in my Column "M" vs all project numbers that match and change the 004 to 005.

Hope this helps

Damm Just realized that some of my Functions were not properly working due to deleting some sheets.

Here updated version Same process but the Textboxes in the userform will now work with Calendar...

Match.xlsm

I guess this is tougher then I thought...
I guess this would be a .find and not a match.

Will post something if I figure out this code