compiling data from 3 sheets

Hi,

Let me say hello to everyone as it's my first post here.

Wonder if anyone will be able to help....

So, I have data in 3 sheets. What I need to do is to calculate total rates for shops in different zones in certain time frame

Basically I need to multiply "drivers payment" (column E, sheet 1) by certain amount (let's say 1.5 for zone 1, 5 for zone 2 ect.) for a certain time period (column A, sheet 1).

All data as i mentioned earlier is spread over 3 sheets as per attached file.

Any ideas how to do it?

Thanks
M