Macro to transfer row of data between sheets based on certain criteria.

Sorry, I didn't initially understand the context of the question. But if it's to keep in line with the 12 month time line for the other sheet, it could be 2 months out.