Sub Decomp()
Dim ListNom, Dico, i As Long
With ThisWorkbook.Worksheets("Data")
If .FilterMode Then .ShowAllData
Set Dico = CreateObject("scripting.dictionary")
For i = 2 To .Range("A65536").End(xlUp).Row
Dico(.Cells(i, 1).Value) = .Cells(i, 1).Value
Next i
ListNom = Dico.keys
For i = LBound(ListNom) To UBound(ListNom)
ThisWorkbook.Worksheets.Add after:=ThisWorkbook.Worksheets(Sheets.Count)
ActiveSheet.Name = ListNom(i)
.Range("A1").AutoFilter Field:=1, Criteria1:=ListNom(i)
.Range("A1").CurrentRegion.Copy Sheets(ListNom(i)).Range("A1")
Next i
If .FilterMode Then .ShowAllData
End With
End Sub