Extract data based on cells names across sheets

Hello
I have many spesific cells and columns containns names , what I want matching amongst sheets DETAILS with TABLE 3,TABLE 4 then should brings all of data where next to adjacent cell for cell name or under it .
the cells ,columns as I put in sheet DETAILS(DISTRIBUTOR CODE,SHIPMENT DATE,DESTINATION,PRODUCT CODE,BRAND,QTY,TOTAL SHIPMENT QTY,CONTR#,SEAL#). and if the rows are alittle and the BRAND are more than rows inserted in sheet DETAILS then should add before TOTAL SHIPMENT QTY rows with the same borders . and if there is duplicate item as column B( BARND) should merge and sum the values whether duplicates item are in the same sheet or across sheets as in item 1,4 as I put the result in sheet expected . as to TOTAL SHIPMENT QTY,DISTRIBUTOR CODE,SHIPMENT DATE will repeat for each separated range should just choose one of them and ignore the rest .