Simple Excel - 'Data Manipulation / MACRO

I have 26 worksheets very similar to the attached. The $ price shown in Zone WX is my cost price. I want to increase this by 60% i.e 1.6 and replace the Zone WX price with my selling price. So if Zone WX price is $100 it will become $160. The column Direct Container, where it appears, needs to be removed. I don't want to see a string of 0 where a formula is just copied down. I don't want to see that my price is arrived at my multiplying by 60%. The selling price just needs to be there for the customer to read. Better still if your bid says that you will do a macro where I can change the mark up perhaps from 60% to another number. This is not a huge project so please bid sensibly. The file is large so you need to make sure that you can email and send a file of this size. I can't zip a file. Can never get it to work.