Hide Unhide Columns on certain cell value

Hi,

I need to write a macro to hide and unhide columns in multiple speadsheets on particular cell value (say Yes/No).

I have 6 excel worksheets - Sheet 1 - Sheet 6.
In first worksheet (Sheet 1), I have given a condition to be provided by user in terms of "Yes" or "No".

In case, if in the first worksheet the condition provided is "Yes", I have to hide Coumns F, G, H and K in other five worksheets.