Code to go to a specific column name on all active sheets and delete all rows conaining 0

I would appreciate any help in writing a macro to go to all active sheets and find the column named "Market." Once that column is found I would like to delete all rows containing 0. I would then like to go to column 1 of all active sheets and delete all rows containing "national assignment." I tried recording the macro within excel but it does not work correctly when recorded because of absolute references that change with each data update. Thank you.

I may be using the wrong terminology, but I have 4 sheets that represent product names. All 4 feed into a main master sheet in the same workbook.