Sub Extrait()
Set f = Sheets("Base")
Application.DisplayAlerts = False
Application.ScreenUpdating = False
'--- Liste des noms
f.[A1:F10000].AdvancedFilter Action:=xlFilterCopy, CopyToRange:=f.[I1], Unique:=True
For Each c In f.Range("I2:I" & f.[i65000].End(xlUp).Row) ' pour chaque nom
f.[i2] = c.Value
On Error Resume Next
Sheets(c.Value).Delete
On Error GoTo 0
Sheets.Add After:=Sheets(Sheets.Count) ' création
ActiveSheet.Name = c.Value
'-- extraction
f.[A1:F10000].AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=f.[i1:i2], CopyToRange:=[A1]
Next c
End Sub