Sub Recopie()
Dim J As Long
Dim I As Integer, Ligne As Long, x As Integer
Dim Ws3 As Worksheet
Dim Ws4 As Worksheet
Dim Ws5 As Worksheet
Dim Tablo
Set Ws3 = Sheets("Feuil3")
Set Ws4 = Sheets("feuil4")
Set Ws5 = Sheets("Feuil5")
Ws3.Select
Ws3.Cells.Select
Selection.ClearContents
Selection.ClearComments
Ws4.Select
Ligne = Range("A" & Rows.Count).End(xlUp).Row
Tablo = Range(Cells(Ligne, 1), Cells(Ligne, Cells(Ligne, Columns.Count).End(xlToLeft).Column))
For I = 1 To UBound(Tablo, 2)
x = Ws3.Range("A65536").End(xlUp).Row + 1
Ws5.Rows(Tablo(1, I)).Copy Ws3.Rows(x)
Next I
Ws3.Rows(1).Delete
End Sub