Need Column A and B to move with Column C when information is transferred to Column C

All info goes to the master inventory and then if some enters an amount for respray then it is transferred to the respray sheet. when it is transferred to the respray sheet it put the date in Column A and then put 3 days later in Column B.


Every day it will change and the date in A1 changes to tomorrow but if another item is enter as having resprays then it transfers to the respray sheet and will bump down in column C but Column A stays the in the same spot.


I need Column A and B to move up and down if something in Column C moves up or down and it would be nice to always have the oldest date at the top.