Need code to delete column if cell contains certain value

I am attaching a sample file for reference.

On the sheet titled Price List, in row 1, I have an =IFERROR(HLOOKUP( formula to show what I need. The Data Pull sheet can be updated using a third party software, and retailers can be added or deleted. The purpose is that if a retailer is deleted from the Data Pull sheet, it will automatically be removed from the list on the Price List sheet, rather than just showing a bunch of N/A's in every cell. Then if it is re-added in the future, it will repopulate on the Price List sheet.

The formula I have in row 1 is my manual way of showing whether or not the retailer was deleted. If it contains EXCLUDE, you can go in and manually delete the column. However, I would rather have a macro do this.

Please let me know if you need more clarification, and thanks for the help in advance!

That code worked for the deletion - but I cannot reverse that so it would readd the column if it were reincluded in the future. would that be an entirely new set of code, or can you modify that code you just provided?

So if one week, Target was removed from the Data Pull worksheet - that code would work to remove target from the Price List worksheet
however, if the week after, Target was re-added to the Data Pull worksheet, that code did not work to re-add Target to the Price List worksheet.

Would you know how to solve that problem?

Actually - I do not need to repopulate cells.
That code worked great.

THANKS!!!!

This code no longer works in the file. When I first was using it it ran exactly how I wanted it to. Now it does nothing.

Would changing the file name have anything to do with that? Tab names? I have no idea what is wrong, I did not change the code, or the layout of the sheet.

Any help would be great!