I have 24 sheets named as Nov-2007 through to Oct-2009.

I have VBA code that names the sheet according to the content of the sheet.

The way it works, when Dec 07 comes, Nov-07 will be named "Expired" until
new data is entered in the sheet and will be named Nov-2009 but will be the
first sheet when I would like it to be the last sheet.

Is there code that will do a sort by date so Nov-2009 goes to the end,
leaving Dec-2007 as the first sheet.

Thanks