Help building updating pages

Hey guys, I'm new here, so if there's already a post answering my question, please just point me in the right direction, and I apologize in advance. I need help pulling information from one sheet that has repeated data and bringing it to another.

Excel Help.PNG

If I've got these three columns, and I will create a separate sheet for each Name (John, Jill, etc.), and I want Excel to pull each different account associated with a given name and the number of sales associated it, so that each individual person's page looks like below, with nobody else's information on it:
Excel Help 2.PNG
Excel Help 3.PNG

I'm pretty sure I'm going to need to use Vlookups (but I'm not sure how to handle the fact that I want to pull the multiple names) and I don't know how to get it to update the individual person's sheet each time a new row is added in the original file (maybe macros? but I'm not sure). My back-up plan is just to run a sort by names at the end of the week, then copy-and-paste, but I'd much prefer to have Excel do it automatically.

Can you guys help me with the formulas and everything that I'd need for this?

Thanks,
Kevin

You can try with PowerQuery add-in for Ex2013

Or a Pivot table

See the file