Copy Data From Multiple Workbooks Into One Workbook?

I'm trying to set up an excel that will allow me to gather data from multiple workbooks and get it into one master worksheet. All of the worksheets are formatted the same way (See below)

Employee Last Name
Employee First Name
Employee Position
Employee Series Number
Departing City
Departing State
Attended Pilot Training?

We don't have the data yet so the idea is to paste this information into their perspective worksheets and then have them automatically populate into the master tab.