Missy:
The Macros using VB script editor is very powerfull. I believe you can diferenciate the way the macro perform looking for one specific cell in your excel file. I really enjoy the way that I can produce report to my manager in the field. All of them have different number of store assign so the macro should be very smart to discriminate between one manager and other. I dont know how expert you are in Visual Basic but if you have experience at least with basic, you can do it.
If you need more help, we are here to help you.
HAPPY NEW YEAR!!!