Microsoft Excel - Creating a list based on cell value

My company is divided into Regions, Districts and individual store locations.  I am building a spreadsheet that would show performance by each of these groupings.  I want to be able to populate a list of regions, districts, or stores based on user selections made from data validation lists.  Right now my data validation lists are set up so that a user can drill down into the data. 

For example - if a user selects Region 1, the district data validation list only shows districts that belong to Region 1.  Likewise if a user selects a region and corresponding district the store data validation list only shows stores that belong to the district selected.

Below these 3 data validation lists I would like to find a formula/code to do the following:

If a user in the "Regions" field selects "All" I need to have a listing of all regions populate the spreadsheet. 

If a user selects "Region 1" instead of a listing of all regions I need to have a listing of all districts belonging to Region 1 populate the spreadsheet.

If a user selects a any Region/District combination I need to have a list of all stores belonging to the chosen district populate the spreadsheet.

If this possible?

Hi Patrick:

if your data is really located in a single worksheet you could experiment with Excel's built-in Autofilter function... Have you tried that?

Best wishes,
Rolf