Combining Columns from Different WorkSheets

I was wondering anyone can help, I've got 3 worksheets with data coming from different sources and I need create a new worksheet based the combined data from a single column. Basically I need to be able to take the unique name column from each workbook and generate a single unified column. I need this to be dynamic so that changes to the 3 original sheets are reflected in the new column. Something like this:
Combining_Columns.png

Google's letting me down on this one, all I can get is how to concatenate columns.

Thanks in advance. (First post, be nice )