Help! Script that filters excel data

[Jafori]

Hi
I´m working with my master thesis in Mathcad and the last step is to export about 1 million values to excel
I want to filter those values and choose the highest value with certain requirements.
To make it easier, i will just ask for a small macro that i can later develop and work with on my own.

I want a macro that
1. Sort the result with this order no matter how many rows the set of data is
first order: Cell A3 to A(end) A to Z
Second order: Cell B3 to B(end) A to Z
Third order: Cell C3 to C(end) lowest to highest
Fourth order: Cell D3 to D(end) highest to lowest

2. After the filtering the result in the same sheet on the same columns and rows.
I want to take out the row with the highest value in column D for each unique set data in column A, B and C
and print those on another sheet named "sheet2"

So in this example i start with this:
pic1.png
And want to end up with this sorted Data:
pic2.png
And with those result on sheet named "sheet2"
pic3.png

the whole idea with the sorting the data first is not to loop through all 500 000 rows but just to loop until column A, B or C is changed and then proceed to take out the next value from the following rows. (if the sorting is done properly it means the first unique row with respect to column A, B and C)

Who ever helps me get a honorable mention on my master thesis in the introduction
and a small donation to a charity like the Red Cross, value 20 dollars to honor you
my file found herehelpme.xlsx

I want it as a macro button just to click and perform the above.
Thank you