Linking multiple sheet columns into one master sheet column

[RubaDude]

I have Excel experience but am a complete newbie to VBA and not sure if VBA is even relevant but:
Is it possible to link a dynamic column from different sheets in a workbook into one master sheet column in the same workbook? For example (please see attachment): I want Column A (Name) in Sheet"New" and Column A (Name) in Sheet"Old" to populate Column A (Name) in the Master Sheet, and when I enter data into either Column A in "New" or "Old", it automatically updates the Master Sheet by adding the new data to the end of the list. Thanks for any help or advice.

[大灰狼1976]

Hi RubaDude!
Please refer to the attachment.