Ok I can do this but like I mentioned before I need to know what worksheets to ignore. The reason is because The code will look through every worksheet name and if that name is not in the D5 to D50 list it will get deleted. Now if the only worksheet left to spare is the worksheet where you enter data into d5 to d50 then that's really easy however If it is not then you will run into a problem.

Let me know which worksheet names to spare (Data validation will not keep them from getting deleted.) or if I just need to spare the main worksheet.

Thanks