Excel Auto Update with Formula

Dear All,

Greetings, Please Help.

Here with I have attached file of "DIESEL REPORT MANUAL ENTRY_MAY 2015". In that file having two sheets names "Summary" and "Issued".
My requirement is when I entering the Diesel Issued datas in to the Issued sheet at the same time will update automatically in the summary sheet as per the transaction date for that Diesel Issued to particular Jobs Number. Kindly get the solution with Excel suitable formula function.


Thanks & Regards
iqubalemco