I have 4 columns

Sheet Name(Defined Name) Reference To delete
sheet1 xxxxxxxxxxx yyyyyyyyy x
sheet1 zzzzzzzzzzzz yyyyyyyyy
sheet2 eeeeeeeeeeeee yyyyyyyyy x

Based on the first column it should go to the sheet name(i.e if it is sheet1 it should activete sheet1) and it should identify the names(Insert-name-define) in it and which are marked as to delete it should delete them.