Ok, I need a little help please. I have a master file along with 9 other worksheets in a work book. I am wanting to make a script or function, not sure what to use. I have a list of "officers" and each officer has their own worksheet. So within the master, all officers are listed, and from there I would like to seperate them into their own worksheet. Any ideas on how to go about this?

Thank you for your time and help.