Sub test()
Sheets("1").Select
Range("G30").Select
Selection.AutoFill Destination:=Range("G4:G30"), Type:=xlFillDefault
Range("G4:G30").Select
Sheets("2").Select
Range("G30").Select
Selection.AutoFill Destination:=Range("G4:G30"), Type:=xlFillDefault
Range("G4:G30").Select
Sheets("3").Select
Range("G30").Select
Selection.AutoFill Destination:=Range("G4:G30"), Type:=xlFillDefault
Range("G4:G30").Select
Sheets("4").Select
Range("G30").Select
Selection.AutoFill Destination:=Range("G4:G30"), Type:=xlFillDefault
Range("G4:G30").Select
Sheets("5").Select
Range("G30").Select
Selection.AutoFill Destination:=Range("G4:G30"), Type:=xlFillDefault
Range("G4:G30").Select
Sheets("5").Select
Range("G30").Select
Selection.AutoFill Destination:=Range("G4:G30"), Type:=xlFillDefault
Range("G4:G30").Select
Sheets("6").Select
Range("G30").Select
Selection.AutoFill Destination:=Range("G4:G30"), Type:=xlFillDefault
Range("G4:G30").Select
'etc... sur tous le classeur sauf les 3 dernières feuilles.
End Sub