Sub Supprimer_feuilles()
Dim plageNoms As Range, d As Object, cel As Range, s As Object
Set plageNoms = Range("D29,F29") 'à adapter
Set d = CreateObject("Scripting.Dictionary")
d.CompareMode = vbTextCompare 'la casse est ignorée
'---liste des feuilles à supprimer---
For Each cel In plageNoms
d(CStr(cel)) = ""
Next
'---suppressions---
Application.DisplayAlerts = False
For Each s In Sheets
If d.exists(s.Name) And Sheets.Count > 1 Then s.Delete
Next
End Sub