Excel Dashboard Creation

I have reports that need to be created for management. Currently there is a lot of Manual work being done in generating these reports are it is prone to error. I would like to Simply these reports and have them all generated as a dashboard in excel.