Merging multiple workbook sheets into master workbook

Hi, I have 14 workbooks that have the same number of columns and titles to each column are the same also. I would like to merge all 14 workbooks into one master workbook and have it update automatically when new data is entered into one of the 14 workbooks.
Is there a VBA code or a linking of the documents somehow to achieve this?

I have given three samples of worksheets in three different workbooks. Do I just copy one of the workbooks below and rename it "Master" and then add the VBA code?

Thanks so much for your help!
Lin

Would you need the source workbook as field too? or at least the Stenographer's name?

Hi,
Yes, I would like to have the stenographer's name or something to identify which workbook it is coming from.
Thanks.
Lin

Hi,
I would need the steno's name. Do you have any thoughts on this?
Thanks.
Linda

You could add another column and put the name of the workbook in that column to know where the data came from? This is over my head with VBA but I would also assume you would have to give us the folder or directory where all the workbooks are located. Or at least where you will store the master workbook?