Help for silent auction bid winner worksheet

[Jnines]

I have been using Excel spreadsheet for silent auction info for 3-4/ years. We have never had it right to get bid winners list of what they won with total amount. I need to have it sorted by bid numbers at end and then total the items each bidder won. I know this will be so much better automated but I can't seem to figure out the right formula.

[shg]

Post the workbook ...