Define Then Extract Data Recalculate Totals

I receive an order spreadsheet from a customer see attached .rar file. I have had to compress as it is 101kb.

Each row is one order with the information of what is required including the data.

Some orders need to be dispatched on the day before (these orders are standard and are always dispatched the day before.)

I would like a solution that would let me define the orders dispatched the day before, remove them and the total from the original day and recalculate the data. There is a week’s worth of data that is sent from the customer and the orders may be duplicated during the week but need to be fulfilled.

Attached is also an example of how the data could be sorted

Nine Elms Sheet the data would be imported from the customer,
Criteria would define the orders that are dispatched early,
The pre tabs would have the orders found that meet the criteria set and totalled (pre Monday would be Tuesdays dispatched early)
The day tabs would have the other orders totalled after the early orders have been removed.