Need A Way To Search And Delete Cells

Hello

I have a way to add peoples holidays and save it to the next sheet but I need a way to cancel them so how can I find and delete the information form the next sheet.

For example if I was to fill in all a the cells with a someone holiday information it would delete the matching information from the next sheet

I have uploaded my sheet to better explain

Thanks