Hey Ab33 thanks for replying and offering help! I'll try to be clearer...

In this example the worksheet contains a table in which the data that I want to delete resides. In my live environment this will change on a daily basis.
The worksheets in the live book are made up of these unique references some of which are live and some of which I want to delete.

In this example book that I have attached I would want the VBA to look through the list of all items in the table (this may contain one item or hundreds) and delete the worksheet that is defined on each line of this table but leave all other worksheets intact.

I hope that this helps explain what I am trying to achieve?