Super merci Pédro, ça fonctionne :
Sub AllColleEtSauve()
Dim AllServ As String, Cellule As Range, LaDate As String
For Each Cellule In Range("SERVICES")
LaDate = Format(Date, "YYYY-M-D")
ThisWorkbook.Sheets("Synthese").Range(Cellule.Value).Copy
Workbooks.Add 'Ouvre un nouveau Fichier XL
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Selection.PasteSpecial 8
Next Cellule
End Sub