"Automation" across multiple sheets

I have a dashboard that pulls information from a report that gets it's information from 15 different sheets. There is some conditional formatting and cell population on each sheet based off the date. Depending on the date (month) different information will populate in the report that rolls up from the sheet.

Today at the beginning of each month I have to manually go into each sheet and click save (just open the sheet and click save) in order for it to turn over to the new month for the report.

Is there an automation or something that could be setup to say when I click on a single button or action - it opens each of the sheets individually, waits 3 seconds then saves it so the new month registers In each sheet which in turn updates the report (and ultimately the dashboard) instead of having to it I manually for each one.

Thanks in advance for your help!