Sub transfert()
Dim c As Range, d, Col&
Application.ScreenUpdating = False
Workbooks.Open Filename:=ThisWorkbook.Path & "\Données.xlsx"
With ThisWorkbook
With .Sheets("Feuil1")
d = .[c3]: Col = Application.CountA(.Rows(3))
For Each c In .Range("b5:b" & .Cells(.Rows.Count, "b").End(xlUp).Row)
With Workbooks("Données.xlsx")
With .Sheets(CStr(c))
c.Offset(, 1).Resize(, Col).Copy
.Cells(Application.Match(CLng(CDate(d)), .[a:a], 0), 2).PasteSpecial , Transpose:=True
End With
End With
Next
End With
End With
Application.CutCopyMode = False
Workbooks("Données.xlsx").Close True
End Sub