I work for a company with retail stores grouped into regions and smaller districts.

Let's say region number 1 consists of 3 districts - # 123, #234, #345

Each of those districts contains multiple stores
#123 - stores x, y, z
#234 - stores a,b,c
#345 - stores d,e,f

I want to be able to create a list of districts/stores based on a user inputs. I already have data validation lists set up so that a user can select a particular region and further select a particular district that belongs to that region, and further select stores that belong to that district.

If user selects Region 1 in the first data validation I need a separate list to populate as below as:
# 123
# 234
# 345

If a user then selects district # 123 from the second data validation I need a list of stores belonging to that district to populate as:
x
y
z

Is this possible?

Here's how the final spreadsheet looks with the 3 data validation drop downs:

\1