Sort by Merged Cells

Thanks again for any help.
I have attached a sample of how it should look like including merged cells with working formula.

What I am asking is to be able to sort by last column or to highlight cells based off then input of last column.

I hope this helps.