Hi!

I have a workbook with 4 worksheets in total.
The first worksheet contains a list of reoccurring names with assigned tasks.

name assignment Status
Jack Do x
Jill Do y
Jack Do z
Frank Do s
Jack Do q
Jill Do p

The additional worksheets are exclusive to the users who's names are on the list. Those worksheets automatically copy the data from the first worksheet (the data above).

When a user either is done with the assignment, he/she will write "done" or "in progress". They will do so on their own sheet.

So now, I would like to find a way so that the first worksheet's "Status" Column will aggregate the correct user input values from the other worksheets to the corresponding name.

I hope that made sense.

Thanks in advance!