Permanently sort a Col depending on Colour

Hello,

Please see the attached for more information.

In Col A (current layout) every cell that contains a 1 has conditional formatting 'cell that contains..' 1 and turns red. I want every cell that is red to be grouped at the top of my page like Col D / E.

I am hoping for a formula that sorts the information as per Col D / E.

The information in Col A/B will be changing on a daily basis and I do not want to keep having to use the 'sort' function every single time to get my desired D / E look.