Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim Plage
Select Case Sh.Name
Case "AAAAA", "BBBBB", "CCCCC"
With Feuil1
Set Plage = .UsedRange
Sh.Cells.Clear
Plage.AutoFilter Field:=6, Criteria1:=Sh.Name
Plage.Offset(, 5).Resize(, Plage.Columns.Count - 5).SpecialCells(xlCellTypeVisible).Copy Sh.[a1]
Plage.AutoFilter
End With
End Select
End Sub