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