Loads Multiple Sheets from Drop-down List

Hi All,

I'm hoping you might be able to help me. I'm trying to put together a report that managers can update on a monthly basis, without having to re-input data each time, or without having to create multiple individual reports.

The idea is that all reports would be stored and hidden in a single document. When opened, managers would be able to select their names from a drop-down and this would "load" all the tabs/sheets that pertain to them - see attached.

Is there anyway this can be done using VBA/Macros?

Many thanks in advance, and I look forward to hearing from you!

Kind regards,
G

You write the code on the start sheet to look to see if the cell changes. If it does then you have it change the visible sheets. See the attached file where I have done that with your example.