I need help. I have a workbook assigned to 4 different consultants. They collect the same type of information. Some consultants will have more than others in each tab. The consultants may update their workbooks daily or weekly. There are two tabs, Referrals and Randoms, for each consultant.
I would like to know if I can merge the data from each workbook into a master workbook for our lead consultant. Each time the lead consultant opens the workbook it updates with any changes the 4 consultants make in their own workbooks. Also, if the lead consultant could also edit in the master workbook that would be great.
I have attached a sample of the master workbook.
Thank you for any help!
Bookmarks