Create a drop down list that Filters and displays data from multiple worksheets

[ziarck]

Hi,

I have an excel file that has six tabs (Master, Southern, NGI, Momase, Highlands, & Summary).

The worksheets Southern, NGI, Momase, & Highlands are Regions which contain data respective to each region such as:

Province
District
District Accounts
MBR Delay (Months)
AFS Delay (Years)
MBR Average (District)
AFS Average (District)
MBR Average (Province)
AFS Average (Province)
MBR Average (Region)
AFS Average (Region)

Each Regions Worksheet contains the same format and I would like to summarise the four worksheets data on a Summary Worksheet using Districts as a filter showing only rows of related data for a selection made using a drop down list or some other method.

The output should resemble below:
Region Name
Province Name
District Name
District Accounts
MBR Status
AFS Status
Average Delay MBR
Average Delay AFS

Is this possible??

[tim201110]

with your file maybe

[ziarck]

@tim201110

could you give some details on how I can achieve this?

Thanks