I have a workbook that includes commission sheets for 10 sales people. I
want to create a macro that will move a copy of each sheet to its individual
file. How do I do that with out going to each file and moving each sheet
individually?

Thank you.