Additional workflow/automation actions

Scenario: In our project, we have a weekly reporting cycle. In some of our sheets, we have a field that is "previous status" or "previous actions" or other similar ones, you get the idea.

Desired action: have an automated flow where, once the end of the cycle is reached (any configurable date, friday evening for example), the values in column "previous status" gets replaced with whatever is in the "updated status" column.

I feel like there may be a way to do it with formulas and the "today" function? What do you think?

Now that we're on the subject, additional actions like "generate extraction" or "move entire sheet one row down/one column to the right" could also be good ideas maybe?

Cheers,

Elvis