Accessing multiple files in our organizational SharePoint site

I have several reports that require analysis for monthly audit purposes. The 9 files are located in our organization sharepoint site and all are formatted differently. All files need to combined into...