Dynamic Combobox help

A combobox may not be the best solution, just what I'm thinking at the moment.

The situation:

I have a set of data (1 sheet) that is updated frequently.

There are three "tiers" of data to filter on. The basic task looking at the raw data (with Filter) is

1. Select "Top Tier"
2. Select "Second Tier"
3. Select "Detail Tier"

This narrows down the fields to show what you want. Basically, 3 columns are "drill down" columns and 3 more is the important data to display.

My Problem:

I'd like to make a user interface to make this easier for end users

My idea is to have a combo box for each "Tier". So the user just selects each drill down and then clicks a "Display" type button that will display the 3 important data columns in some fashion.

How do I get combo box selections to change based on the previous tier selection? I hope this was enough information, any help would be greatly appreciated!

Take a look at this thread for a possible solution... http://www.excelforum.com/excel-prog...te-a-cell.html