If I had access to the spreadsheets I could see using the methods you've described. Unfortunately this data is coming down the proverbial pike from the corporate office in Denver. They send down these huge spreadsheets and then want the office I'm in, to pull data. The file names are always different because they use dates within the file name. However the data in the workbooks is always the same format.
One of my co-workers, who has Excel 2013 on their computer, is going to try running one of the macros to generate a report this coming Monday. I don't think we've tried this one on Excel 2013. I'll try to get details on the errors and post them here next week. Thanks for your reply.