Rolling Total from Budget Sheets

I'm finding this hard to articulate, so hopefully this makes sense:

I have budget spreadsheets, month to month, within the same workbook. These have various categories (bills, luxuries, consumables, subscriptions, etc.) which I populate with expenditure, as well as totals so I can view my monthly surplus/deficit and a graph so I can see into which of the various categories my spend each month falls.

Each new month, I create a new sheet which is a copy of the same format, and populate it for the new month.

I want to create a dashboard which will automatically pull information from, say, the last six months so I can see my combined and by-category expenditure from those months, without having to manually update sheet references in the formulae.

What I am looking to do is tell Excel something along the lines of: "sum the totals in cell C5 on the next six sheets in this workbook", so I don't have to have "SUM(April26!C5,March26!C5... etc.)" which would need manually updating in every formula when I added May26 and wanted November25 to drop off.

Possible? TIA.