|First, a posting tip:|
Before posting any more VBA code in this forum, please click on the blue line at the end of this post and read the instructions on how to post code and data in this forum.
As for your question, one way to accomplish your goal is to loop through the sheets and delete the ones with the names you are looking for.
You'll note that we loop through the sheets in reverse order because deleting sheets while counting forward messes up the For-Next loop. e.g. If Sheets.Count = 6 at the start of a forward counting loop and then a sheet gets deleted, there will only be 5 sheets left. The code would then fail when it tries to access Sheet(6). By counting in reverse order, we eliminate that issue.
For sht = Sheets.Count To 1 Step -1
Sheets(sht).Name = "Instructions" Or _
Sheets(sht).Name = "Example DEF" Or _
Sheets(sht).Name = "Assembly status" Then
Application.DisplayAlerts = False
Application.DisplayAlerts = True
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.