Moved entire row based on date

I am under a tight deadline to get a product out and cannot figure it out. I figure this has to be done with a macro, and I am clueless with those. Basically what I need to do is have the section "Future Leave Requests" (rows83 and below) filled out, when the departure date hits, then the row would need to move up to the "personnel on leave" section (Row10-36).

Same thing goes for the TDY section, the future section (rows 168-182) move up to Current TDY (rows40-55)

Even if it had to be two sheets to make it easier, I would be fine with that.

Would I be able to add in rows as needed without screwing it up?

Thanks for any and all help.