A to Z format

HiGretc1865 

This post to help you to sort your sheets 

I believe you will need to use VBA, open the VBA editor by pressing Alt+F11 --> from Insert menu -> click on  Module.

Copy the below code and save the file.

Now, to sort the sheets, open the Macro window by pressing Alt+F8, then run the macro with the name Sort_Active_Book

Sub Sort_Active_Book()
Dim i As Integer
Dim j As Integer
Dim iAnswer As VbMsgBoxResult
'
' Prompt the user as which direction they wish to
' sort the worksheets.
'
   iAnswer = MsgBox("Sort Sheets in Ascending Order?" & Chr(10) _
     & "Clicking No will sort in Descending Order", _
     vbYesNoCancel + vbQuestion + vbDefaultButton1, "Sort Worksheets")
   For i = 1 To Sheets.Count
      For j = 1 To Sheets.Count - 1
'
' If the answer is Yes, then sort in ascending order.
'
         If iAnswer = vbYes Then
            If UCase$(Sheets(j).Name) > UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
'
' If the answer is No, then sort in descending order.
'
         ElseIf iAnswer = vbNo Then
            If UCase$(Sheets(j).Name) < UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
         End If
      Next j
   Next i
End Sub

Gretc1865 
go to data tab
under sort & filter choose sort command as shown below 
get to sort by drop down and select first priority that you want to arrange

lets say column b is your priority and order it a to z
then click on add level and choose remaining priorities

final result shown below

Gretc1865 

Filter for unique values or remove duplicate values

In Excel, there are several ways to filter for unique values—or remove duplicate values.

You will find more informations in the upper link.

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)