Sub Extrac_Images()
Dim lig&, col&, C As Range
lig = 3: col = 28
Application.ScreenUpdating = False
With Feuil2
.Rows("3:" & .Rows.Count).Clear
For Each C In Feuil1.Range("b3:b" & Feuil1.Cells(Feuil1.Rows.Count, "B").End(xlUp).Row)
C.Copy .Cells(lig, col)
C.Offset(, 7).Copy .Cells(lig, col + 1)
col = col + 81
If (C.Row - 2) Mod 5 = 0 Then lig = lig + 1: col = 28
Next
End With
End Sub