Sub Ajouter()
Dim n, k, tx, onglet, deb, init,nb
init = "FM" ' les 2 premi?re lettre du dernier onglet
nb = 7 'nombre d'onglet ? copier
ActiveWorkbook.Unprotect "AIRBUS"
For k = Sheets.Count To 1 Step -1
If Left(Sheets(k).Name, 2) = init Then
deb = k
n = Val(Replace(Sheets(k).Name, init, ""))
tx = Replace(Sheets(k).Name, n, n + 1)
Exit For
End If
Next
For k = deb - nb +1 To deb
Sheets(k).Copy after:=Sheets(Sheets.Count)
tx = Replace(Sheets(k).Name, n, n + 1)
ActiveSheet.Name = tx
Next
ActiveWorkbook.Protect "AIRBUS"
End Sub