Sub Recopie()
Application.ScreenUpdating = False
Range("B1,B3:B6").Copy
Sheets([B2].Text).Cells(Rows.Count, 1).End(3)(2).PasteSpecial Paste:=xlPasteAll, Transpose:=True
Sheets("Tableau général").Cells(Rows.Count, 1).End(3)(2).PasteSpecial Paste:=xlPasteAll, Transpose:=True
Application.CutCopyMode = False
Range("B1,B3:B6") = Empty
End Sub