Option Explicit
Private Sub CommandButton1_Click()
Dim FeuilleCible As Worksheet
Dim Cell As Range
Dim CellToCopy As Range
Set FeuilleCible = Worksheets('Feuil2')
For Each Cell In Range('B2:E26')
If Not IsEmpty(Cell.Value) Then
Set CellToCopy = FeuilleCible.Range('A65536').End(xlUp).Offset(1, 0)
Cell.Copy CellToCopy
End If
Next
End Sub