Excel to Powerpoint report generator

I have an excel sheet with name of staff, dept , grade level and field of study. I want to have selections maybe using VBA, where i can generate a simple report in powerpoint. Summary of staff by dept, field of study and also grade level.
a drop down to select dept and get a pie chat to show grade level distribution and also field of study distribution for that department.