Hi.
We have a spreadsheet we use to keep track of quotes requested by clients. These get entered as they come in and are assigned the next Q number (e.g. Q0002). Since not all clients request their quotes back in the same amount of time the order in which quotes need to be done is not chronological.
I already have a column calculating the days left until the due date and have conditionally formatted the dates to change colour as the due date gets closer. Once the quoted have been finished and sent to the client a status is entered in the status column (e.g. PENDING, WON, LOST, etc)

I was wondering if there was a way to have a second sheet for example that listed all the quotes not yet submitted and sorted them by due date and then sort by time due, and possible another sheet with quotes not yet submitted sorted by the person responsible and then sorted by due date and then by time due.

I have tried getting this to work with pivot tables, but it seemed to require an extra dimension than they could handle. Perhaps I need an extra dimension...

Here is a section of the spreadsheet with some info changed, but all formulas etc still intact.
quotes TEST.xlsx

Thanks in advance.