Sub a()
Dim F, i%
F = Array("Feuil1", "Feuil2", "Feuil3", "Feuil4")
For i = 0 To UBound(F)
With Sheets(F(i))
.Range("A1", .Range("A" & Rows.Count).End(xlUp)).SpecialCells(2, 23).Copy _
Sheets("SYNTHESE").Range("A" & Rows.Count).End(xlUp)(2)
End With
Next i
End Sub