Delete worksheets that are no longer required

[TedX]

Hi Everyone,

I'd like to create a macro, but I am not sure how to go about it. I have a workbook that I update every day which creates some new worksheets and corresponding new connections. Please see the image below. After I have taken a copy of the relevant data, I have to delete the worksheets and Connections each day manually. The worksheets always have 'Append1', whilst the other worksheets I don't need all follow the naming convention of 'Table 5' as an example. I never know how many tables there will be, each day is different, but they are all variations of the word Table a space and a number. It's the same with the connections. Can anyone create the VBA code for this macro for me please?

 

[DanteAmor]

Thank you, that has cleaned up the code from 3 macros down to just one.

Im glad to help you.

Note: You should mark as an answer the post that actually answered your question. Unless your own answer is the solution.

 

[TedX]

“In space no one can hear you scream.”

LOL, finally I have met another crazy person, you have made my day, thank you again