I see this being very useful when you need specific terms used for a database application. Random entries would need to be cleaned up. This would prevent that.
How would you set it up to delete from one sheet and apply it to another? Like the video you wanted to have the first tab as "Active Projects" and within the drop down menu when you select "Complete" it will delete from "Active Projects" and move it to another tab called "Completed Tasks" so that you can keep track.