Hello all this is my first post and I am looking for some help. I have looked/searched through the forum and cant really find what I am trying to do.
Scenario:
I have multiple workbooks (6) located in various sharepoint site libraries. There is various information updated by different departments which is based on training start dates. (rows updated by each department are scattered throughout the document.) Basically there are 5 departments with documents and 1 master document. Each time a department modifies there respective rows it should update the master. The reason for the separation is due to need-to-know reasons. I know I can accomplish the task through manual copying means but setting that up is a tedious task. Is there a way to accomplish this task through VB means. I cant post the documents due to sensitivity. An example of such would be preferrable with explanations if possible so I can modify accordingly.

Once again 5 working docs 1 master all seperate files with different network locations. Information consolidated to a master from the 5 source files. Any help would be greatly appreciated.