Sub Consolide2()
Dim NbLg As Long
Dim Ws As Worksheet
A = Array("AK1", "AK2", "AK3")
With Sheets("CONSO")
If .Range("A2") <> "" Then
.Range("A2:AG" & .Range("A" & Rows.Count).End(xlUp).Row).ClearContents
End If
For Each Ws In Sheets
Select Case Ws.Name
Case "CONSO"
Case Else
For n = LBound(A) To UBound(A)
If Ws.Range("A2") <> "" And Ws.Name = A(n) Then
NbLg = Ws.Range("A" & Rows.Count).End(xlUp).Row
Ws.Range("A2:AG" & NbLg).Copy _
Destination:=.Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End If
Next n
End Select
Next Ws
End With
End sub