So I have a schedule I am working on for some stuff at work and Id like to auto-sort it by name but I can just use the auto sort I need a specific sorting method. Please check the .xls file attached to the post for the data. Heres what I need done.

Step 1: I need a macro that runs by itself that is not attached to just one excel page as this schedule is generated in another piece of software then exported into this file each week so the page always changes but the macro has to work the same on all pages.

Step 2: Basically all I need is the macro to search through "column B" and reorganize it according to a pre-defined list of names. So for example it would look for the names Tommy, Scott and Micheal and group them and make them all one highlighted color, say red or blue. Of course it would grab the entire row for each name and move it with the name.

Step 3: Lastly I want it to delete rows one through 11 (the info at the top) and the entire A column.

Thats it, if you have any idea on how to do this it would be a huge help, even a link to a tutorial to something similar to this or a part of this would help! Anything at all! Thanks in advance!

Schedule.xls