Help on macro to automatic transfer of data from multiple workbooks to master wkbk

Hi,

I have a master file called Outbound Source and 6 other files filled out by other users. I want to be able to automatically update my master file whenever they enter data on it. All workbooks are in a shared folder. Please see attachments