Tool to calculate transportation expenses - please help

Dear all,Billing T4.2013.xls

Before reading my explaination for the situation, please open the file attached and see sheet "daily report" for the first reviewing

Please help me with this situation, I'm an accountant and my Company hired a number of transportation suppliers who will bring our products to customer by truck. And my job is that: i have to calculate the transportation expenses based on the quantity of each truck (column No 9 in the sheet "daily report" attached); unit price/truck (column 18 - which will get from the transportation rate in the sheet "Data billing A") depend on each kind of truck, and other extra cost (column 20-23). Because I have about 7 supplier around 5 area- it mean that I have to set up about 35 report like the file attached. Each supplier I have to filter the data (Column 5) follow the supplier, then the truck No (column 6), after that sum up total weight per trip (column 7-9) then calculate the expenses (column from 18-25).

Do anybody can develop this table for me as when I import the data, the system can recognize like that: they will sum-up all orders belong to one truck and verify that where the truck come from which supplier and fall in the rate of that supplier, calculate the expenses, extract those to the report like the sheet "daily report".

I know that it will really help with a software but my company did not spend money for it, and I have to do by myself, but for the No of report above, I'm overloaded and too stress everymonth.

Please help me,

thank you very much