Hi All,

In the attached spreadsheet, I have a macro that splits up the data based on category and creates 9 separate files within the same folder.

These files are then looked at and updated by other employees, and what I'm looking for is a macro that will then take the updated 9 files and consolidate them back into the original workbook on a new Sheet, in the same format that they are originally (but with updated numbers of course).

Let me know if you can help, or if you need any more information.

Thanks!general 2015 percentages.xlsm