Hide/Unhide Sheets based on drop down list

Here it is.
As you can see in VBA I have the code for hiding rows which is connected on cell C4.
Now I would like to put your code for hiding sheets based on criteria in C5.
e.g. if I selected in C5 = "All Divisions" then show me all sheets. If it's selected "Financial" hide all except "Region FIN", "Control Tab", "Calculations" and "Actuals".
Or if I select "Retail" ---> hide all except "Region RET", "Control Tab", "Calculations" and "Actuals"

I hope so this is an appropriate example for you.
Thank you very much for help.