Hiding Columns

I apologize - I'm so close to having this. One last question - Regarding the hiding columns, if I wanted to have the drop down in a different sheet than the sheet where the columns are being hidden, how would I change the macro?

Also, instead of picking "Yes" or "No", it will work like this - if the user selects "Client 1" then the equivalent of "Yes" will hide, if the user selects any of the other clients, then the equivalent of "No" will hide.

Thanks again!