Sub ListerFeuilles()
Dim shListe As Worksheet
Dim sh As Worksheet
Dim i As Long
On Error Resume Next
Application.DisplayAlerts = False
Sheets("Liste").Delete
Application.DisplayAlerts = True
On Error GoTo 0
'Créer ou re-créer la feuille
Set shListe = ThisWorkbook.Sheets.Add(before:=Sheets(1))
shListe.Name = "Liste"
shListe.Range("A1") = "Noms"
i = 2
For Each sh In Worksheets
If sh.Name <> "Liste" Then
With shListe
.Hyperlinks.Add Anchor:=.Cells(i, 1), Address:="", _
SubAddress:="'" & sh.Name & "'!A1", TextToDisplay:=sh.Name
End With
i = i + 1
End If
Next sh
shListe.UsedRange.Sort key1:=shListe.Range("A2"), Order1:=xlAscending, Header:=xlYes
End Sub