I have roughly seventy workbooks all with multiple sheets (anywhere from 2 to over 500). Every workbook has a summary page that pulls data from all sheets in the book. What I would like to do, is create another workbook as a "master summary". In this I would like to have all the summary sheets from my other workbooks be the worksheets in this master summary so that I could create a single worksheet that has a grand total of all my data.
I know how to copy these summary worksheets into my master summary and have the data update automatically every time I open it. However this only works if I keep all the rows and columns of my seventy some summary sheets the same.
My problem is that as time goes on I will need to add/remove rows and columns, switch them around, etc... on these individual summaries. Is there a way to make a workbook with worksheets that just "clone" a worksheet in another workbook every time you open it? Basically I need to be able to make a worksheet that can automatically pull every cell with data in it from a sheet in another workbook regardless of rows and columns being moved, added, or deleted.
Thanks for any help.
Bookmarks