I am creating an Excel file that will be used by multiple persons.  Each person will enter data in their own worksheet from time to time, so data will keep adding on to each sheet.  I also want to have a master sheet that all the data that each person entered will be automatically populated to whenever they are entered.  Any suggestion in how to do it?  Thanks.

Hi,

According to your description, I recommend we try to use VLOOKUP function.
e.g. =VLOOKUP(A2,Sheet2!A:B,2,FALSE)

You may download a sample file in this thread:

https://social.technet.microsoft.com/Forums/office/en-US/14cc7ba3-c8c0-4785-a35c-5edde166c8f0/how-to-get-a-data-auto-populated-from-one-sheet-to-another-sheet?forum=excel

Regards,

George Zhao
TechNet Community Support