This may be a difficult question to answer, because I can't supply the exact macros I'm using but I will try to give a good description.
Essentially the original workbook has data for multiple sales branches across different categories. The macro essentially makes a new workbook for each...