Without spending too much time looking at your question, it would appear to
me that what you really need/want is a pivottable. A pivottable gives you
the ability to "drill" different info out of your database and it is
extremely easy to set up. To try it, just highlight your data and select
Insert Pivottable (Excel 2007) or datapivottable (I think, Excel 2003).
Give it a whirl....