sumif and vlookup

Hello community,

I have the 1st table below that contains different MP.

I need a function in B2 that sums all the mp1 in other tables from different sheets

that I want to sum from many product table like the picture after

this is an example table and I need a formula that may gather all