Hi all dear helpers!

Attached are the workbook example!show.xlsx
I have a big problem, How do i connect the relevant data in two sheets?

For example, HOW should i do if i wanna count how many sales guys i have under country X and Y for Bronze Partner type?
AND is there anyway for me to extract those data i want and let them list out?


Thanks a lotttttttttttttt!