On both sheets, insert a new column before all other columns, col A
In cell A2, enter the formula =B2&"_"&C2 and copy down. Repeat for 2nd sheet.
Enter the following formula into cell F2 of sheet Master, and copy down:
=IF($E2<>0,E2/SUMIF($A:$A,$A2,$E:$E)*IFERROR(VLOOKUP($A2,Table!$A:$I,6,FALSE),0),0)
cyiangou - Need macro to populate spreadsheet based on cross referencing of tabs.xlsb
Does this help?