Dynamic Range for Multiple Sheets

So formulae can have dynamic ranges within a sheet, such that additional inputted data will in turn be detected and the reporting adjusted with the formulae.

Is this a possibility for multiple sheets? If the sheets were named a certain thing with a changing number within the title, could it be constructed? What would this formula look like?

Or is this, more likely than not, a macro-based issue?

Can post workbooks as necessary.

P.S. Apologies for having a thousand and one threads open. I have too many requests