Tabs In Hide/Unhide Out Of Sequence...

What do you mean by "Out of order"?
AFAIK the sheet names will always be listed in the same order as their position within the workbook.

In the pics, they show tabs for...
1. Wk #...
2. Billing Wk #...
3. April '20...

Most of these tabs that I've hidden are sorted correctly, assuming it's sorting in alphabetical order. So I'm hoping someone can explain why the pics show some tabs out of order. It's making it more difficult to find what I need when I try to unhide a tab as I have to sort through many mix matched tabs. I was hoping this was an easy fix but it seems maybe it's not and I know it's difficult to explain this which is why I'm hoping someone can see the differences I'm talking about form the pics I posted.

The naming convention is the same with the exception of either Wk or Billing Wk and then the #. So why is Excel showing some out of order such as the 2nd pic shows ...#42

...but it's 'Billing Wk #42 10.14-10.20' so it should be sorted further down where the rest of the Billing Wk tabs are sorted. Same with the 3rd pic. and the 4th pick showing months.

Like I said, I'm assuming Excel sorts these tabs once you hide them in alphabetical order but even if Excel doesn't, I have tried hiding them in order and Excel still shuffles them around with no rhyme or reason. ???

Excel does not "sort" the list, the hidden sheets should appear in the same order as there position in the workbook.
So if you hide the 1st sheet in the book, that sheet should always appear at the top of the list. Are you saying that is not happening?

Fluff13, you are right! It sorts these tabs depending on where they were originally in the workbook! I tested it by selecting Unhide, then simply moved the tab and selected Hide again and it sorted it where I wanted it!

So I must have moved some of these before not realizing it but now that I know how it works I can fix this and keep them all in order to find them again.

Thank you very much!!!

You're welcome & thanks for the feedback.