Create Summary Page From Multiple Worksheets

[Drake07]

Hello,

What I am looking for is a method/code to create a summary page that will fetch data from multiple worksheets to a single worksheet. I looked online and there is a code that partially gets me what I want, but not entirely.

https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

Essentially, each worksheet containing the data I want to summarize always starts at a specific location (A17). However, the number of rows with data will vary depending on the worksheet. So if I would type in a range, it would be something like "A17:S??".

I created a sample excel sheet of what I am trying to do. Sheet "Summary from Macro" would be the ultimate goal. Each time the macro button is clicked, it would fetch all data from the data pages (ignoring the "Click" sheet), with whatever data exists on those pages, within that range. If the summary page already exists, I would like it to delete the previous version with the fresh version

The number of worksheets can be variable, the rows on each sheet are variable. The worksheet names are not always consistent either.

[davesexcel]

Test this out.

Please Login or Register  to view this content.

[Drake07]

works perfectly!

I will be tweaking it a bit to do the nitpicky details I want after the data is populated. You saved me hours of work with copy/paste nonsense for each sheet.