Hi,

I have a fairly large workbook, with 3 sets/groups of sheet name.
1) Cal yy, (where yy = the year)
2) mmm yy (mmm = month, yy = year)
3) Qn yy (n = 1/2/3/4, yy = year)

and an input sheet.

The code currently creates each sheet as required. I would like to be able
to sort them in their groups. Is it possible to sort the sheets in the order
the sheet name appears in a specific column, so that as each sheet is created
the new sheet name is added to the bottom of the list and a unique sort order
list is created for the code to refer to.
If that is not the best method please advise. If that sounds ok, please
advise.

Thanks in advance for your help

Richard