Option Explicit
Sub essai()
Dim Cellule As Range
Dim LigneCell As Long
Dim ColonneCell As Integer
Worksheets("TOTO").Activate
For Each Cellule In Range("A15:D15, F5, H5, J5, L5")
LigneCell = Cellule.Row
ColonneCell = Cellule.Column
Cellule.Copy
Worksheets("TITI").Activate
Cells(LigneCell, ColonneCell).Offset(-4, 0).Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Next Cellule
End Sub