Changing dates and removing rows with VBA

Hello, I have a pre-existing code that has been written before my time. I would like to modify it since I am taking over the excel spreadsheet. The way that this all works is very complicated, but what I need to be done should be straight forward in one section of the code.

There are a total of 3 excel spreadsheets that are open. The main spreadsheet has a button that copies all the cells from the other 2 spreadsheets and dumps them into 2 different tabs for proper formatting and analysis.

What I need to add:
Before the cells are selected in one of the spreadsheets I would like the data to be cleaned up a bit.

1. In Column J "Date Made" I would like to have all dates to be changed to the earliest date found. So let's say that column J has 10/22/2019;10/23/2019;10/21/2019; I would like everything to be changed to 10/21/2019 because it is the lowest date.

2. In Column K "WO#" I would like the entire row to be deleted if a number starts with "9". So if row 10 has a number that starts with 9 in Column K, delete row 10.

Section of the code that I think that this needs to be added to from Module 1 (Full code attached):

Please Login or Register  to view this content.

One small problem, I forgot to mention that these are special cases. Most of the time all the dates are the same and there are no numbers that start with 9. It's the special cases that screw everything up.
So when I ran the code that you have written, I got an error saying that there are no numbers that start with 9 in Column K. I also had to correct it from Column L to K.

Please Login or Register  to view this content.

I have attached a sample spreadsheet. The data that needs to be changed is on the "WOFile" Tab. Would you please create a new module and insert the code there. I will then incorporate it into the proper button.

Thank you.

Ok, I messed around with the code that you have written and was able to get it to work properly. Big thanks for writting this.
Final Code:

Please Login or Register  to view this content.