Hello,

I am working on a project where I have to pull data from about 40 different workbooks into a separate data-workbook. However, each workbook is continually adding new sheets. What I would like to happen is for each time I add a new sheet to one of the workbooks, to have a fast and efficient way to add the data I need to the master data-workbook. I am posting this question in this forum because I was hoping there would be a way to have a Macro in place to transfer over the data. If more information is need on the project to find an answer I would be happy to add on.

Thank you in advance for any and all help!