Afternoon from a sunny RSA,

Four sheets, three are input sheets and the last one is a summary sheet.
Sheets 1 to 3 are vehicle specific. Truck 1, Truck 2 and Truck 3.
One each sheet is three columns, Date, Driver and Kilometers travelled, so
therefore each row would have for example in cell A2=2007/08/16 B2=David
C2=162
Now each vehicle sheet would have similar information. Just the dates,
driver and kms would obviously change.
Driver David does not necessary always drive the same vehicle. His
co-workers are Paul and Simon. And they also switch vehicles.
I want on the summary sheet to show on a particular date that David drove so
many kilometers and the same calculation for Paul and Simon.

Hoping in anticipation.