Change sheet index numbers in VBA?

Thanks shg,
There's an old saying: experience (and knowledge) is something you get right after you really needed it. I had always assumed that the index order of worksheets was that which appeared in the VBE project window, i.e. sheet1 had index 1, sheet2 had index 2, etc. No matter what I did I couldn't get the sheet numbers in VBE to follow the same order as the tabs, regardless of how they were named.

Shortly after seeing your note I experimented further with my multi-sheet application. And sure enough, the index numbers tracked the tab order. Now I've been able to simplify some aspects by using Worksheets(index) instead of Worksheets("name"). I guess that the Sheet# in VBE identifies the order in which they were created, regardless of the way they may have been rearranged.

I consider this matter to be resolved, and the thread can be marked solved.