How can I arrange this data?

I’m now in charge of our envelope inventory. It’s spread out in a number of locations in the warehouse. I’ve given the locations unique labels and there are unique labels for each type of envelope as well.

I have an spreadsheet with a row for each location then I enter what type of envelope is in the location and the quantity.

What I’m looking for is a way to call up the data by the type label and easily total what quantities I have of that particular type of envelope from the various locations.

Spread sheet headers look like this:

Location Client Description Qty Inventory Date

I have Excel 2007 and Access 2003 to work with. This is pretty simple, but I just can’t see the solution.

Thanks