Sub SyntheseG()
Dim Wkb As Workbook, ResWkb As Workbook, Ligne As Long
Set ResWkb = Workbooks.Add
Ligne = 2
For Each Wkb In Application.Workbooks
If FeuilExist(Wkb.Name, "synthese") Then
Wkb.Worksheets("synthese").Range("A10").CurrentRegion.Copy ResWkb.ActiveSheet.Cells(Ligne, 1)
Ligne = ResWkb.ActiveSheet.Range("A65536").End(xlUp).Row + 1
End If
Next Wkb
Application.CutCopyMode = False
End Sub
Function FeuilExist(NomClas As String, NomFeuil As String) As Boolean
Dim a As String
FeuilExist = False
On Error GoTo Err1
a = Workbooks(NomClas).Worksheets(NomFeuil).Name
On Error GoTo 0
FeuilExist = True
Exit Function
Err1:
End Function