I have compiled a workbook with sheets "1-13" and the 14th Sheet "Summary" and 15th Sheet "Charts".
In Sheet "Charts" I have placed some list/ dropdowns.
By these dropdowns user can select what type of analysis the user wants and for which period? ( Like we see on http://www.devinfolive.info/censusinfodashboard/)

The graphs which would be displayed on Sheet "Charts" would be displayed on different indicators on Sheets 1 to 13 and 14th Sheet Summary.

How I can link these graphs so that it can be updated automatically as well as it will be dynamic also.

Not able to attach excel sheet for reference