Drop down list Sum Function

Greetings all, im extremely new at this whole Excel thing that involves more then just reading and typing a list out. So here is what i am trying to accomplish. I am trying to make a spreadsheet that tracks fuel, mileage, and hours on a set of vehicles. Plan is this:

__________________________________

Column A Column B Column C Column D

Vehicle Fuel Miles Hours
E1 12 123 5
c4 6 23 2
D3 43 56 90
E1 3 5 2
__________________________________


Totals:
Total Fuel: (all of column D which i know how to do)

E1: Fuel: (total fuel used for this vehicle)
Miles: (Total miles used for this vehicle)
Hours: (total hours used for this vehicle)
C4: Same as above

so on and so forth

Basically, i will have a drop list within the cell with all the vehicles. I am wanting a total fuel usage (which i have figured out), but i want to make another "Totals" list based on the vehicle. This list will be listed in the order in which they call in over time. My question is, how do i format the sum cell to read the list in column a based on the vehicle if that makes sense

Does that makes sense? If you have any questions please ask!

upload sample excel file

make a pivot , i mean on all data first press ctrl+A and Alt+d+P then enter 4 times you will enter into pivot from the right hand side drag drop the items in Row lables and Values please find attached the sheet for your reff.fuel.xlsx

Attached is a small idea of what im looking for

I guess what im looking for is, in the total hours(fuel or miles) for the respective vehicle, how can i select the vehicle put in the information, while it automatically updates the rest of the totals at the bottom

So i figured out the pivot table and the end result is exactly what i want. However this is an ongoing form that is used and updated often. However i would like to be able to have all the tables figured out and sorted and when new data is put into the base data table, it automatically recalculates everything in the final tables.

It seems with using the pivot table, its only for data that's already available.

Does that make much sense?

You can Change the Data Source so every time Data is added it will be picked by Pivot table , you have to right click on Pivot and Refresh pivot every time new data is added in Source pic attached for reference.

pivot .jpg

Oops double post.

Pivot format attached. Hope this is the one you are asking.