Bonjour Quik,
Voici une macro qui fait ça,
Sub Transfert()
Dim Dico As New Scripting.Dictionary
Dim team, sh, Cle As String
Dim LastRw As Long, i As Long, y As Long, rw1 As Long, rw2 As Long
Set sh = Sheets("Team by Team")
LastRw = sh.Cells(Rows.Count, 2).End(xlUp).Row
team = sh.Range("B1:B" & LastRw).Value
For i = LBound(team) To UBound(team)
Cle = team(i, 1)
If Not Dico.Exists(Cle) Then Dico.Add Cle, i
Next
For y = LBound(Dico.Keys) To UBound(Dico.Keys)
If Not y = UBound(Dico.Items) Then
rw1 = Dico.Items(y)
rw2 = Dico.Items(y + 1) - 1
Else
rw1 = Dico.Items(y)
rw2 = LastRw
End If
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = Dico.Keys(y)
sh.Rows(rw1 & ":" & rw2).Copy Range("A1")
Application.CutCopyMode = False
Next
Set Dico = Nothing
End Sub