Option Explicit
Private Sub Worksheet_Activate()
Range(Range("a2"), Range("d2").End(xlDown)).Clear
With Sheets("BDD")
.Range("a1").AutoFilter
.Range("a:l").AutoFilter Field:=4, Criteria1:="="
.Range("a2:a10000,c2:c10000,f2:f10000,l2:l10000").SpecialCells(xlCellTypeVisible) _
.Copy Sheets("Sommaire").Range("a" & Rows.Count).End(xlUp)(2)
.Range("a1").AutoFilter
End With
End Sub