Excel 07 worksheet focus macro

[tarshm]

Hi i have a pretty good understanding of excel with the exception of macros so heres my question:

Basically im setting up a spread sheet to cost infrastructure projects and i would like the macro to operate as follows: when a council zone is selected "say council A" from a drop down menu i then want to be able to click a button or something and depending on which council ive selected bring me to the relevant worksheet

so selecting council A > hit button with assinged macro > bring to council A worksheet..and like wise for B, C and so on

cheers guys

 

[tarshm]

Is this even possible? i would have thought such an action would have been reletively easy.