Report not sorting properly after adding the year



Help. My report, which is sorted alpahbetically, was exactly how we needed it to appear until I had to add "2023" before each sheet name and now it seems it has a mind of it's own.

"2023 Call Center..." should come before "2023 COBRA...." and "2023 SA Out of scope.." moved it's way up in the list. I have removed sheets, added sheets in a different order and it keeps reverting to the sort you see here. What is going on?? It's happening in another report as well and I need these to be in ABC order on a dashboard.

Thanks for you help!

Best Answer