Sub consolider_B()
Dim ArrWks, ws As Worksheet, ligne As Long
ArrWks = _
Array("ales", "arles", "bagnols", "calvisson", "grau du roi", "montpellier", "nimes", "uzes")
Application.ScreenUpdating = False
With Worksheets("consolidation")
.Rows("6:" & .Cells(Rows.Count, "A").End(xlUp).Row).ClearContents
For Each ws In Sheets(ArrWks)
ligne = ws.Cells(Rows.Count, "A").End(xlUp).Row
ws.Range(ws.Cells(3, "A"), ws.Cells(ligne, "K")).Copy
.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Application.CutCopyMode = False
Next ws
End With
End Sub