VBA to create object specific excels based from the rolled up data

Hello,

I am trying to create a dashboard, which shows particular parameters in graphs based from filters using multiple input tabs with data. Due to security reasons, I would need to limit data for only particular managers, which forces me to create more than 80 of the same dashboard with limited availability of data.

I have created a sample worksheet to represent my conundrum (attached)

VBA needs to do:
1. Duplicate the dashboard for all unique fruits, that could be found in tab “Dropdown” in column B (a.k.a. calculation should return 4 fruits, hence 4 unique excel files) – please assume that the area B4:F20 does not have blank spaces, i.e. if calculated across all column it would return more counts than there actually are
2. Each unique excel file should bear information only for a particular fruit (i.e. 4 files with information for separate fruits):
3. For the “DropDown List” tab the following needs to be done:
- Column B – delete all fruits apart from the fruit of the dashboard and move cells up
- Column C&D – based on the value in column D (fruit) – delete the combination of columns C&D inputs (paired up for particular row) for all fruits apart from the fruit of the dashboard
- Columns E&F – based on the value of column F (fruit) – delete the combination of columns E&F inputs (paired up for particular row) for all fruits apart from the manager of the dashboard
4. For the “Data 1” tab, delete the whole rows of data based on the value of column B (fruit) for all fruits apart from the fruit of the dashboard
5. For “Data 2” tab, delete the combination of cells in columns A:D based on the value in column D for all fruits apart from the fruit of the dashboard and move cells up (so that columns F onwards are not affected for any fruits)
6. For the “Data 3” tab, delete the whole rows of data based on the value of column A (fruit) for all fruits apart from the fruit of the dashboard

Any tips and approach to tackling this task would be greatly appreciated!!

Thanks,

E