Sub test_B()
Dim vArr, Feuilles, i%, Rng As Range
Feuilles = Array(Array("RECOPIE 1", "CLASSEUR 1"), Array("RECOPIE 2", "CLASSEUR 2"))
For i = LBound(Feuilles) To UBound(Feuilles)
With Sheets(Feuilles(i)(0))
vArr = Sheets(Feuilles(i)(1)).ListObjects(1).DataBodyRange.Value2
.Range("A7").Resize(UBound(vArr, 1), UBound(vArr, 2)).Value = vArr
.Range("A6:E6") = Array("DATE", "LIBELLE", "MODE", "DEBIT", "CREDIT")
.Columns.AutoFit
Erase vArr
Set Rng = .Range("A6").CurrentRegion
.ListObjects.Add(xlSrcRange, Rng, , xlYes).Name = "Tableau_" & Int(Rnd * 50 + 1)
End With
Next
End Sub