Automatically consolidate and sort data from appended Excel file

Hi, I have have an Excel file that is appended from another application. The application inputs the data and saves the file to a new name/location and then opens the file. I would like the data to be automatically consolidated and then sorted after the data is inserted.

I am looking at inspection data from multiple parts, multiple requirements, and multiple results. The requirements are numerically labeled and I need the data consolidated and sorted to a single minimum and maximum value for each requirement. I can do this manually and might be able to figure it out if the file name and location didn't change. The new file name just adds a date stamp at the end of the original file name.

SHEET 1:
Consolidate example SHT1.JPG

SHEET 2:
Consolidate example SHT2.JPG

SHEET 2 After Consolidate and sort:
Consolidate example SHT2_after consolidate and sort.JPG

Consolidate example.xlsx