bonsoir
Sub personnes()
Dim sh As Worksheet, _
My_Sheet As Worksheet, _
cel As Range
Application.ScreenUpdating = False
Set sh = Sheets("Nom")
For Each cel In sh.Range("A3:D" & sh.Cells(Rows.Count, "A").End(xlUp).Row)
For Each My_Sheet In ThisWorkbook.Sheets
If CStr(Right(My_Sheet.Name, 1)) = CStr(cel) Then _
My_Sheet.Range("A" & My_Sheet.Cells(Rows.Count, "A").End(xlUp).Row + 1) = sh.Cells(cel.Row, 1)
Next: Next
Application.ScreenUpdating = True
End Sub