Need macro to populate spreadsheet based on cross referencing of tabs

Instructions are also within the attached.

Need to bring "Table" volume into "Master" highlighted column. I do not have material on "Table" so it's hard to do. I need a formula/macro that breaks down the promo volume from "Table" down to material level for "Master." Only way to do this is by looking at LY Volume.

Please see Zone EE & Promo 50745 on "Master" for example. 715,452 is the Sept total for EE/50745 on "total" tab. I broke that number down to the materials listed on "Master" tab by inputting a formula. I don't have time to do this for every single promo combination. Is there a macro or a better formula that involves lookups so I can do this in a quick manner??

Let me know with any questions or suggestions, thanks.