Hide Columns with Drop Down list

I want to write a macro that will hide columns base on a drop down list. My drop down is located in Cell A3 and contains 6 names. These names are located in each column (C through the end of the worksheet) in row2 (C2 to ???2). The names appear in random order. When I select a particular name from the drop down I want the macro to hide the other 5 names not selected.

So far I've got

Please Login or Register  to view this content.

But I can't figure out how to write the case to hide the columns I want hidden

I obviously don't know what range goes with which case, but here is how I would do it w/ kind of random conditions:

Please Login or Register  to view this content.