How Do I auto-populate cells in a master workbook by referencing cells in other workbooks that have

[Junuh]

I have a master workbook that I do not want anyone touching. I parsed the data from the master across 3 separate workbooks. Each of the 3 team members has one of these excel workbooks. When they make a call to a contact, they use a data validation list to choose from and mark one of the cells "CLOSED" or "OPEN". I want these statuses to auto-populate the master workbook. I am having difficulty finding a formula to use, given I am referencing cells with data validation formulas.

[#2]

Hi @Junuh 

Please let me rephrase and understand your query correctly.

1. You have master workbook with separate sheet for each user 

2. You wish to populate the information into one mastersheet.

If that is the case then you use Power Query to get all the information into one sheet by using the Power Query Function 

=Excel.CurrentWorkbook()

This video link might be helpful : https://youtu.be/F5fjv6nXvZo

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.

[#3]

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.