J'ai pu trouver ma réponse avec un autre code, pour ceux qui ça intéresse :
En Evènement Worksheet - Change :
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "G4" Then
If Target.Value = "Automatique" Then
Call CopyData
End If
End If
End Sub
En Macro - Module1 - Général - CopyData :
Sub CopyData()
Dim sourceRange As Range
Dim destinationRange1 As Range
Dim destinationRange2 As Range
Dim destinationRange3 As Range
Dim destinationRange4 As Range
Dim destinationRange5 As Range
Dim destinationRange6 As Range
Set sourceRange = Worksheets("Durée de travail").Range("U30:AJ31")
Set destinationRange1 = Worksheets("Planning mensuel").Range("AA8:AN9")
Set destinationRange2 = Worksheets("Planning mensuel").Range("AA59:AN60")
Set destinationRange3 = Worksheets("Planning mensuel").Range("AA110:AN111")
Set destinationRange4 = Worksheets("Planning mensuel").Range("AA161:AN162")
Set destinationRange5 = Worksheets("Planning mensuel").Range("AA212:AN213")
Set destinationRange6 = Worksheets("Planning mensuel").Range("AA263:AN264")
destinationRange1.Value = sourceRange.Value
destinationRange2.Value = sourceRange.Value
destinationRange3.Value = sourceRange.Value
destinationRange4.Value = sourceRange.Value
destinationRange5.Value = sourceRange.Value
destinationRange6.Value = sourceRange.Value
End Sub
Merci quand même à tous !