Long story short I have 153 identically formatted .xlsx files which multiple people enter data into. I am creating a 'master report' workbook that needs to pull that data and combine the totals from those sheets.
I'm using excel 2010 on a windows 7 enterprise machine.
The source workbooks...