VBA to automatically hide rows based on text

I am looking to place a code in a worksheet that when it sees "x" in C10 it automatically hides rows 9 - 21. This process is the same for:

C23 Rows 22 - 34

C36 Rows 35 - 47

C49 Rows 48 - 60

C62 Rows 61 - 73

C75 Rows 74 - 86

C88 Rows 87 - 99

C101 Rows 100 - 112

C114 Rows 113 - 125

C127 Rows 126 - 138

All worksheets are hidden and password protected "ADMIN" and there is a planning sheet where the X is placed and all the above main cells have for example =PLANNING!F23

The idea is that on the main PLANNING sheet the user will enter X for not available and then it will be hidden from view if it has anything else or is blank then it will be visible. Also I would like to know where to place the code as the are 7 sheets MONDAY - SUNDAY

Thanks

Thanks for that, I have inserted it in the module but must have done something wrong as it has no effect. I have attached the worksheet for you to have a look at as it may be clearer?

Kind regards & Thanks again

Will

:-) Nope clearly not paying attention! Password is MASTER

I have tried amending but still not having any joy. Sorry!

wow brill...Thanks it was lower case on the sheet names, I changed them to upper case and it works perfectly!!!