I have people updating four different workbooks and I want this information to automatically be updated in a separate master workbook every time the master is opened.
I found on this forum a perfect example of what I'm trying to achieve, the only problem is that it assumes the individual sheets being updated reside in the same workbook (see attached file). The functionality is perfect using this code, however I would need the ability to define which sheet in the workbooks the data is taken from as there will be more than one.
How can I adapt the code to accommodate the workbooks being separate to the master file I need to update. The individual workbooks can all be located in the same folder, though it would be neater to be able to define the path to each so they can reside in different folders.
Many thanks for any help
Bookmarks