Creating Automation to update a referenced cell between cross referenced sheets


I am looking to create an automation that would run on the 1st of every month. I have a rent schedules calculated and I need cells updated from the rent schedules sheet to the master client sheet.

Take these cells from smartsheet #1 (Cost Schedule)

And update to smartsheet #2 (Client Overview).

Do I need to create a cell in Smartsheet #1 for =Today() to trigger the automation, and then how do I update the conditions and actions to move the information from smartsheet #1 to corresponding smartsheet #2?