Sub Synthèse()
Dim n&
Dim Sh As Worksheet, Sy As Worksheet
Set Sy = Sheets("SYNTHESE")
For Each Sh In Worksheets
If Sh.Name <> Sy.Name Then
Sh.Cells(1, 1).CurrentRegion.Copy
n = Sy.Cells(65536, 1).End(xlUp).Row + 1
With Sy
.Activate
.Cells(n, 1).Select
.Paste
Rows(n).Delete Shift:=xlUp
End With
Application.CutCopyMode = False
End If
Next
Set Sh = Nothing
Set Sy = Nothing
End Sub
Sub Synthèse()
Dim n&
Dim Sh As Worksheet, Sy As Worksheet
Set Sy = Sheets("SYNTHESE")
For Each Sh In Worksheets
[color=blue] Select Case Sh.Name
Case "CR BX ERREUR", "CR CF ERREUR", "CR CP ERREUR", "CR SG ERREUR", "CR BX OK", "CR CF OK", "CR CP OK", "CR SG OK"[/color]
Sh.Cells(1, 1).CurrentRegion.Copy
n = Sy.Cells(65536, 1).End(xlUp).Row + 1
With Sy
.Activate
.Cells(n, 1).Select
.Paste
Rows(n).Delete Shift:=xlUp
End With
Application.CutCopyMode = False
[color=blue]End Select[/color]
Next
Set Sh = Nothing
Set Sy = Nothing
End Sub
Sub consolide_onglets()
Sheets("synthese").[A1].CurrentRegion.Offset(1, 0).Clear
For Each s In Array("1", "2", "3", "4", "5")
Sheets(s).[A1].CurrentRegion.Offset(1, 0).Copy _
Sheets("synthese").[A65000].End(xlUp).Offset(1, 0)
Next s
End Sub