Je n'ai pas à cliquer entre temps !
Par contre je n'avais pas toutes les infos car il manquait des n° f'affaire.
Change la macro par ceci. Remets à jour ton chemin chemin = "C:\Users\Michel\Downloads\zkaw\zkaw\zkaw\FJC\"
Option Explicit
Dim wbk1 As Workbook, wbk2 As Workbook
Dim ws1 As Worksheet, ws2 As Worksheet
Dim rng1 As Range, rng2 As Range
Dim chemin$, monFichier$, onglet$
Sub collecter()
' à modifier ...
chemin = "C:\Users\Michel\Downloads\zkaw\zkaw\zkaw\FJC\"
Set wbk1 = ThisWorkbook
Set ws1 = ActiveSheet
monFichier = Dir(chemin & "*.xlsx")
Application.ScreenUpdating = False
Do While monFichier <> ""
Set wbk2 = Workbooks.Open(chemin & monFichier)
Set ws2 = ActiveSheet
Set rng2 = ws2.Cells(Rows.Count, 2).End(xlUp).CurrentRegion
rng2.Offset(1, 0).Resize(rng2.Rows.Count - 1, rng2.Columns.Count).Copy
Set rng1 = ws1.Cells(Rows.Count, 2).End(xlUp).Offset(1, -1)
rng1.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
Set rng1 = rng1.Resize(rng2.Rows.Count - 1, 1).Offset(0, rng2.Columns.Count)
rng1 = wbk2.Name
Application.CutCopyMode = False
wbk2.Close False
monFichier = Dir
Loop
Application.ScreenUpdating = True
ws1.Cells(1).CurrentRegion.Offset(Cells(Rows.Count, 1).End(xlUp).Row, 0).ClearContents
ws1.Columns(10).Replace What:=".xlsx", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
ws1.Cells(1).Select
End Sub