how to sort a sort data based on headers

Good Afternoon
I was wondering if i could have some support resolving the follow problem
On the attached spreadsheet i have some data under report tab, i need to break that data and transfer across to the master tab, so it will show me every department qty order and despatched rtc by date.
Support with this issue would be much appreciate