multiple sort function and combine cell

Hi,

Am trying to do a macro to sort thing data that we have but its above my skills so if anyone can help.

I have attached a spreadsheet.
In Sheet1 is what we have. then detail and average is what we should obtain at the end.

in detail sheet:
Column A (take from Sheet1/Order OrderSide column with 1=Buy and 2= Sell)
then the others cells are sorted
1- by exchange (replacing code in Sheet1/columnK by the code table in Ex Code sheet
2- by strike in column F
3 -by Option Type (Call/Put)
4- by price

column E,F and G are a split of Column F in Sheet1.


in average sheet:
we need an average (price) of the detail in Sheet1. so we need 1 line per exchange per structure
line 2 for example is equal to the sum of size in Sheet1/Quantity per structure and column H is the average price (sum Column G divided by Sum Column D) per structure

let me know if you can help and if you need more information/clarification

really appreciate