Sub test1()
Dim Wb As Workbook, F As Worksheet, w As Worksheet
Dim Compteur As Integer, Nom As String
Application.DisplayAlerts = False
Application.ScreenUpdating = False
For Each Wb In Workbooks
If Wb.Name Like "Analyse*" Then
For Compteur = Worksheets.Count To 1 Step -1
Nom = Sheets(Compteur).Name
Select Case Nom
Case "Concaténation"
Case Else
Sheets(Compteur).Delete
End Select
Next Compteur
Application.DisplayAlerts = True
End If
Next Wb
End Sub