Extract data from the same range on multiple worksheets in a file to one worksheet

[Rizz]

Hi,

I have a workbook with about 40 visible worksheets and about 3 hidden ones. All the worksheets have different names. I would like to take the data from cells A17:N200 (this would include blank rows in case I end up adding data at a later date) from every single visible worksheet and compile them on to one summary worksheet. And I want to keep it dynamic in case a cell value changes in one of the worksheets, it would automatically update on the summary page.

Is there a VBA code that can do this?

Much appreciated!

[FDibbins]

if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you coujust enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though