Folks I had to have excel reinstalled recently and in doing so, the techy deleted my personal macro workbook. My fault, I should have told him to save that folder. Anyway, I am rebuilding from memory at the moment. just ran into my first problem. I used to have a neat little macro that would look at all the sheets, and if a sheet was in an array, move that sheet before the first sheet. It excluded two sheets when running, one called "Index Sheet" and another called "Mater Outreach". these two sheets are always at the left most positions of the tabs. has anyone got something similar that essentially sorts an array of sheets to the front of the workbook.