Generating a parts list report with subcategories in Excel 2003?

Hi,

It's probably not too tricky, but I can't get my head around this... My question is probably easiest with an example:

Let's say I have lots of parts that I need to keep track of in a building. For example, I need to know that my phone (a part) is in my office (a room) and within my office is on my desk (a location), and on my desk, is located in my bag (a sub-location, for want of a better term.)

I have given each part, each room, each location, and each sub-location a serial number. I have an Excel worksheet that looks a bit like this:
Serial Room Location Sub-location
1234 OFFICE123 DSK12 BAG001

I would now like to generate a report that will tell me what is in each room, and have subcategories to tell me what is in each location and sub-location, looking something like this: (ignore the underscores, they're just to space it out correctly)

ROOM123___DSK001____BAG001____0001
___________________________ ______0006

______________________ BAG002____0003


___________DSK002_____BAG004 ___0034

Or, even better like this:

Room 123___Archie's Desk____Blue Bag____Phone
i.e with human readable names rather than serial numbers...


In addition, I would like to make it easy to change all the part 'properties' if I swap my desks around between rooms (with all the sub-locations and parts on them.) If this can be done from the report, that's great; otherwise a macro might be suitable (however I'm hopeless at programming them...)

Any suggestions or requests for clarification really appreciated. Thanks.

Here's a file with some sample data. It's a bit different to the above example (I'm afraid I can't give you the actual file, as it's for work.) Thanks.