sort data into specific fields

Good Afternoon

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, any help would be much apreciated