Got big proble while generating Master reports and charts

[excel5111987]

In a workbook, I have total 7 (seven) worksheets. As give:
1) Data (in whihch my main and base data exist)(In wich I include every month date)
2) Branchwise (In which branchwise report and chart exist)
3) Zonewise (In which Zonewise report and chart exist)
4) AVPwise (In which AVPwise report and chart exist)
5) PanIndia (In which Panindia chart exist)

And last one is master reports and charts in which I got a problem.
I my last worksheet (Master reports & Chats) I am in need of Mega formula or VBA Code whihch can generate reports and charts beside it if I select drwopdowns like
1) AVP Name
2) Zone
3) Branch.

My points is that formula/VBA Code should work to generate reports and charts beside on a single formate made even if different dropdowns is selected.

For reference I have attached my sample workbook

[DonkeyOte]

Your post does not comply with Rule 1 of our Forum RULES.

Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search.

Poor thread titles will be addressed according to the OP's experience in the forum:
If you have less than 10 posts, expect (and respond to) a request to change your thread title.
If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.