make certain worksheets show/hide when others are clicked

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Edited this time

Depending on your data layout it might be more efficient to store all data in one sheet then use a PivotTable to group by Months & Years

This might helpyou get started

http://excel-it.com/pivot_tables.htm

Post back if you need further help, some dummy data in a workbook would be useful

Please Login or Register  to view this content.

i was thinking about your question a little more and believe this is a better example of what you are looking to do....just creat a sheet in your workbook that would be like a navigation page (dashboard) on that page create a button labled [2009]. add the code above and then save. close and restart the work book and enable macros, click the button and watch it work.

plus the code has explanations in it for you to use. Any how hope this helps.

James

You don't need to close & save a work book when adding code. It will run anyway. Just close & save when finished

with the issue of names, in this case January 09 vs January 10, simply adding an underscore will make all the difference.

January_09 (make sure that both the code and the tab name reflect this)

January_10 (make sure that both the code and the tab name reflect this)


RoyUK..
the reason i stated to save close and restart, is due to the fact that some version of Excel as well as security settings will not allow you to run a macro unless you do this. Not knowing what version of Excel or what his security settings are, leads me to the safest way to test and ensure that the macro will run properly.

You don't need to close a workbook after adding code. Macros will work when added to a workbook that is open.

With 2007 you must save as a macro enabled workbook when finished