Office & productivity software: Microsoft Excel Intermediate Level Question (Formulas)

Microsoft Excel Intermediate Level Question (Formulas)

I have been creating a sheet in which is getting a little more complex than I care to admit. This is what I'm working on:

I have a list that I have been typing manually, and it has to stay that was as per the stipulation of the end result. The list is broken down into four sections going horizontally, and the data goes below.

Type--- Level--- Product---Cost

Name---01------00------02
Name2--02------04------01
Name2--05------01------00
Name4--03------13------02
Name2--05------22------03
Name4--05------03------02
Name3--01------05------02
Name2--04------07------03
Name3--00------02------02

Now what I need to do is to have it break down in a list that below will take the information above in whatever order someone types the names into, and correlates the data into a specific list below it... so it would look like this, again like above it can't be made into a generic list using the wizard because of fields surrounding it.

Totals
Type--- Level--- Product---Cost
Name---01------00------02
Name2--16------34------07
Name3--01------07------04
Name4--08------17------04

Next to the name would be the total sum of each section so if Name2 comes up with as shown above, I would prefer a formula per line so it would be easy to transpose if required... a form wizard can't be used here due to stipulations, and also other fields surrounding it.

Any help would be appreciated.