Please help! I have a item ordering, and order tracking workbook.

Agents can order from a list of items, and in a seperate column select quantity, and a third column select which account to charge it too. I would like to create 4 sheets, one for each of the accounts, but Ill start with one. I will need a table that tallys how many of each item are ordered for that account, and I dont want the items showing up on the tally sheet that havent been ordered. In other words, If three agents order "Grouse" at a quantity of 1 each, and charge to sales promo, the billing-sales sheet will show Grouse 3. Note: quantity will vary as well as the item name and account. I have attached example.

Amenity1.xlsx