please help me...i'm totaly zero knowledge in VBA...

i have running data from others program and then i extract to excel program..
my problem is...
1. the data not in descending order..
i need to do auto descending order using macro...already try copy and
paste the program but cannot run....
2. the running data is at sheet 1 and i plan to do the auto descending order
at sheet two.

can someone help me...already stuck about one week for this problem...
here i attach sample worksheet for your to add the vba...

thanks
muzammel