In regard to sorting only selected sheets, you might be interested in looking at my shareware utilities, at excelutilities.com. They give you the ability to specify the sequence of all or any sheets. You simply enter the tab names in a column (there's a utility to do that for you, too!) and sort the names into any sequence desired. Then Utilities - Workbook - Tab Sequence allows you to make the tab sequence follow the order in the list.