Okay, I've gotten my sort to work properly, and at the right time. My only problem is I cannot get my empty cells to stay at the bottom. I've used this code =" " & 'sheet6'!$A$5 and it works, the empty cells stay at the bottom, but using that code places a #value error in the cell. So, my question, I have my sort macro activated in the change_event of sheet 6, my sorting takes place on sheets 1-5, can I place code into the change_event of sheets 1-5 that counter-act the sort(put the empty cells at the bottom)something along the lines of
=if(Range("A5:A8") = " ", move A9 and A10 into A5 and A6 or something like that?