Deleting Worksheets in a table

Hi everyone,

I've been trying to ammend code that is on the net but to no avail... Anyone know the VBA to delete sheets that are contained within a range at all?

In the workbook I am creating I have a macro that pulls redundant data and puts it into a separate table however from there, I cannot work out how to get the VBA to cycle through and delete only the worksheets that are in this table.

I can get it to delete everything and then the first item but not do what I want.

I have attached a sample work book for you to see if you can help. It has four worksheets each one a colour and a further sheet marked as data to delete which has three of the items on it. Can anyone see how I could run a loop to only delete the sheets in this range?

Help as ever is appreciated

Regards

R