Excel report

Registration date
Monday March 10, 2014
Last seen
September 28, 2018

I create a seller report

Worksheet 1--- I named it as Price list ... is a Data for my seller report that I set a code, name, points and amount

worksheet 2-5--- I named by sellers name which is individual selling report by the seller, then it mind be including other seller name too.

the last worksheet--- I named it summary for my reporting. in this report I differentiation by seller name. I need to report individual total actual selling by the seller

I wonder how do I set when my seller worksheet that which name Pauline, in her selling report got including another seller name Carmen, then my summary will auto show the selling under Carmen selling.

sample file : http://speedy.sh/Zr5bX/Sample.xlsx