Dear Sir/Madam,
You asked for solutions in the proposal. This can be done by adding another column with the formula:
=IF(O2="Yes",2,IF(L2="Yes",1,0))
You can then use the filter keys to sort column A by A-Z then this new column by A-Z. These filters will need to be redone after each time you type in "Yes". It is possible to have the order update automatically, but this would use a macro and I would need to use the real spreadsheet (or a dummy version of it with confidential information censored) to check the work.
Yours faithfully,
Emma