I am working on a spreadsheet where I need to sort numerous bids. Each bid has a date, name, amount, status, and general contractor on sheet 1. I would like to sort these criteria on sheet 5. First I want to sort the bids by year to get the total amount per year. Then I want to sort the yearly total by the status. Then sort the status by the general contractor. If you have any suggestions it would be greatly appreciated! Ive attached a copy of the file to make it more clear. THANKS!

Bid Summary Edit.xlsx