need a formula that speeds up my current complex process!

hi,

(file attached).

im trying to find a way to automate or at the very least speeden the entry of data that you can see in the 'data input' tab. The reason why the data is laid out in this way is so i can create a pivot chart from it showing number of orders split by branch/order type over time.

at the moment im using
=SUMPRODUCT(('w.e. 29th june'!$M$10:$M$105="st albans")*('w.e. 29th june'!$N$10:$N$105="E"),('w.e. 29th june'!$D$10:$D$105))

but i have to change it for every single cell for it to work properly, and thats just for 1 tab, i'd have to keep editing it everytime i added a new tab with a new weeks worth of information on it.

There MUST be a way to speed this up, or put in a better formula which can pull info from a data in a better way, but i dont know how else to go about it.

would really appreciate some help on this - even willing to pay coz im desperate!