How to sort sheets within workbook?

Just make an example, there are 3 sheets (in real case, there could be hundreds of sheets within the workbook, so I need program to do that, 3 sheets as example, just want to explain the issue): from left tab to right tab, the sheet names are ABC_0030 , ABC_0005, ABC_0015

All sheet name has 8 characters, first 4 characters are same, last four characters are numeric.

Under Developer > Visual Basic Microsoft Excel Object: ABC_0030 could be Sheet1 or Sheet2 or Sheet3 , but I don't care about this piece of information. I want to sort the sheets based on its actual tab name.

Goal: I would like to sort the sheets based on last four numeric characters, from smallest to largest, so that ABC_0005 should be the tab on the left, ABC_0015 should be in the middle, and ABC_0030 should be the last tab on the right.

How should I write the VBA code to sort the tabs.

https://learn.microsoft.com/en-us/of...ically-by-name

I think I found the code online.