SharePoint - Multiple Reporting in SharePoint from excel files

My requirement is data comes from many sites and gets stored in the excel file say in 14 tables. From here onwards multiple reports should be generated. How to do this in SharePoint.

With Regards,
Dinesh