HELP : Unhide sheet only the Selected option from drop down list

Hi,

I am stuck to a problem, seeking help from the experts.

Having first sheet named as Data, where I have two drop down list

Grade: m3, m4a,m4b,m5 ....
Location: Factory, Region...

Again, having 10 more sheets as such:

m3
m4a_factory
m4a_region
m5_region
m5_factory
m6a_region
m6a_factory
... and so

Now I want to unhide and make active only that sheet, which I select from the data sheet drop down.
Example: If I select M4A from Grade dropdown and Region from Location dropdown, then M4A_Region should get unhide and active and rest will be hidden.

Thanks in advance,

Sample Sheet is enclosed.
SampleWorkbook.xlsx

Regards,
Shiven

Do you need any addition button(Command button) in your sheet.

Similarly its has the same category

Originally Posted by thameem127

Do you need any addition button(Command button) in your sheet.

No there shouldnt be any command button

Originally Posted by jraj1106

Hi Shiven.

What about the grade "M3"? What category will be associated with it?

Similarly its has the same category