Help

I'm populating a list box with values from my worksheet which is easy enough. But what do I need to do so that If I click on a value on the list box I can activate a macro that will change sheet

For example...I have 7 sheets for 7 days. I want the same drop down list on each sheet that will allow navigation between the sheets

Any help appreciated

GC