Hi... I have a master parts list on one sheet and the parts are counted on two other sheets but are listed in a different orders. The master list is constantly changing and so is the listed order on the 2nd and 3rd sheets. I need to reorder the parts on a 4th sheet to be in the same order as the master list with their corresponding counts from sheet 2 and 3. I can get the totals on sheet 4, I just can't figure out how to reorder sheets 2 and 3 to match the master list order from sheet 1.

I can't use the sort feature, it has to be done by formula. The example below is the basics... Any help would be greatly appreciated.

a.jpg