count and sum duplicates

I have am new here, trying to learn. at the same time facing issue, i am trying to count and sum up the duplicate values into a pivot table type of result. sorry the posts keep saying my code is not properly formatted, unable to share what macros i'm using. i use it to combine multiple sheet into "master sheet to display overall result." but i would like to add in such as counting different duplicate model type at "B" column only and sum it at column J(display model) and I (total quantity) on "master sheet". Thanks if any kind soul could help.