Creating Mulitple Reports and Excel

I have created a sale report in CR 2008. This report looks at each reps performance on a monthly basis. The reports need to be run daily and sent to the Sales Managers. Each manager has several reps that report to them. I need to know if I am able to run this report for several reps at once, but show up on separate reports? Can I take these results and put them on separate worksheets in one workbook in excel? This is the last step in the report creation process and it is driving me crazy. It is not efficient to have someone rerun the same report for the 40+ sales reps we have in our company and then copy and paste them into seperate tabs in excel. Any help would be greatly appreciated.