I have a spreadsheet with 4 sheets in it. I want to have the 4th sheet create a list based upon the first 3. I want the list on the 4th sheet to be updated as changes happen in the first 3, which are maintained by individuals assigned to keep them updated. This is meant to help track assignments of individuals across multiple projects.

More specifically

In sheet 1, 2, and 3 column B will have a list of names. On sheet 4 it will be Column B again, where a list will be created of all the names from the column B on sheets 1, 2, and 3. The lists on 1,2,3 will have some duplicate names and thats fine I want to see multiple entries when a name appears on more than one list.

Just getting a formula or tip on how something like this would be set up would be a great start and GREATLY appreciated. I already know to how to make a cel on sheet 4 read from a specific cel on another sheet. It's the dynamically changing content of the first 3 sheets and how to make a list on sheet 4 with out gaps etc.. that is beyond my grasp right now.

Additional “wishes”,
1. Each name will actually have an associated pair of dates in the next to adjacent cels, C and D. Ultimately I will need to be able to keep them associated with the name they match.

2. I would like to be able to sort the list of names.

THANK YOU in advance!

-Stefan