tu peut créer un bouton et lui affecter cette macro qui vas copier les case avec des couleur différente du blanc dans la première page
Private Sub CopierCellulesColorees()
Dim wsSource As Worksheet
Dim wsDest As Worksheet
Dim cell As Range
Dim rng As Range
Dim destCell As Range
Set wsSource = ThisWorkbook.Sheets("1")
Set wsSource = ThisWorkbook.Sheets("2")
Set wsSource = ThisWorkbook.Sheets("3")
Set wsSource = ThisWorkbook.Sheets("4")
Set wsSource = ThisWorkbook.Sheets("5")
Set wsSource = ThisWorkbook.Sheets("6")
Set wsSource = ThisWorkbook.Sheets("7")
Set wsSource = ThisWorkbook.Sheets("8")
Set wsDest = ThisWorkbook.Sheets("Agenda Réunions CNCH")
Set rng = Union(wsSource.Range("9:13"), wsSource.Range("19:25"), wsSource.Range("32:36"))
For Each cell In rng
If cell.Interior.Color <> RGB(255, 255, 255) Then ' Modifier la couleur si nécessaire
Set destCell = wsDest.Cells(cell.Row, cell.Column)
cell.Copy
destCell.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End If
Next cell
Application.CutCopyMode = False
End Sub