split worksheets based on dropdown

[Cuscosteff]

Good morning, I have a report with 500 separate account results - these are currently set up as a self serve via a dropdown. What I want to do is create 500 separate split worksheets based on the dropdown choice. However I want each worksheet to display all the results /charts etc which are set up based on the drop down (not just the raw data) ?

Hope somebody can help

Thanks

 

[John_w]

What type of dropdown is it? A data validation in-cell dropdown or a form combo box, or something else?