Sorting Sheets

Good morning all,

Amongst others, I have a number of sheets that have a numeric name, i.e.

Summary
Totals
123456
235465
909876
127645
Template

I used to sort them using the below code:

Please Login or Register  to view this content.

Annoyingly now some of the sheets are now being numbered with a letter at the end, i.e.

123451a
123451b
123451c

Can anyone help me modify the code to sort these too?

Hi ChrisMattock,
try this (Snb's code)

Please Login or Register  to view this content.

Nilem - that's great, thanks!

I added a couple of lines after the code to put my summary sheets back at the front...

Please Login or Register  to view this content.

Thanks so much for your help!