Auto Sort

Hi Leith-
Attached is an example. The actual sheet will look very similar with hundreds more entries. The first sheet is pre sort, the next is what I want the sheet to look like after one sort and the third after a second sort. You can see that I'm changing an entry in column A from 1 to 0, and want that entry to go to the bottom of the list. Obviously I want all the formulas to remain the same.
Thanks!