Sub Copier()
Dim source As Workbook, dest As Workbook, n%, lig1 As Variant, lig2 As Variant
On Error Resume Next
Set source = Workbooks("exemple_Resultat.xlsm") 'à adapter
Set dest = Workbooks("exemple_prono.xlsm") 'à adapter
If Err Then MsgBox "Les 2 fichiers 'exemple_Resultat' et 'exemple_prono' doivent être ouverts...": Exit Sub
On Error GoTo 0
If source.Worksheets.Count <> dest.Worksheets.Count Then MsgBox "Le nombre des feuilles de calcul n'est pas le même !", 48: Exit Sub
For n = 1 To source.Worksheets.Count
With source.Worksheets(n)
lig1 = Application.Match("Jeu Simple (1 €)", .Columns("A"), 0)
lig2 = Application.Match("2 sur 4 (3 €)", .Columns("A"), 0)
dest.Worksheets(n).Range("AY43:BB" & dest.Worksheets(n).Rows.Count).Delete xlUp 'RAZ
If IsNumeric(lig1) And IsNumeric(lig2) Then _
.Range(.Cells(lig1, 1), .Cells(lig2, 4)).Copy dest.Worksheets(n).Range("AY43")
End With
Next
End Sub