ISO Excell Expert

I have this clerking sheet that i have been using, and i have tried using pivot tables, but i can not get the information to show like i need it to. the line # is the number we assign the the item won (col a), consignor (column B) bid and qty, then who it was sold to. i want to consolidate buyers purchases. for example in the sheet attached, frank bought more that on thing, and i would like that to show up in a table, telling me what frank bought, with a total amount due. I would also like a consignors report of what consignor sold what. My next "want" for this sheet... is i have an area at the top of clerk sheet where i enter the data, for current item being bid on. i fill it out hit enter, and it populates below and keeps a running tab of everything i enter. I've spent a few weeks trying to figure it out and i fold. i have an example sheet of what data i need drawn into groups