Okay,
You look on column A list which has a drop down list, so if you pick up the name of sheet from list A, it has to be deleted. Is this right?