Copy Worksheet Multiple Times to New Workbook, In Order

First of all, I created a thread yesterday that User: Leith Ross [Thanks Leith for the help yesterday] was helping me with yesterday. This is a separate question and should be a simple solution.

I have the following code I'm using to cycle through items in a drop down list, then copy the sheet each time it's updated with a new item to a new workbook. The one thing missing I'd like is if I could have the sheets go in order in that new workbook. Currently - it's a list of 26 cities in alphabetical order - they populate into the new workbook in reverse order, since I'm using =before... I'm sure there is a simple solution i'm missing? I've included the workbook if that helps...

v2.SectorTemplateHelp.xlsx

Please Login or Register  to view this content.