Yes it does and reasonably fast also. Good idea of you to sort the cites before running the macro. It's so much easier to find a specific city among 51 others when sheets are added in alphabetical order.

So as far as I see you just need one macro so you either choose "Test1" or "Test2" both work equally well but "Test2" has the nicer headings in my opinion.

As this solves your problem don't forget to mark your thread "Solved"

Alf

Ps
To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved