I was wondering if someone could help me with a macro.

I want to have a drop down menu with values (Choice A, Choice B, Choice C, etc.) and have tabs (Choice A, Choice B, Choice C, etc.). Would it be possible to write a macro that will automatically go that will go to the appropriate tab when I select an item in the drop down menu?

Thank you in advance for any tips.