Help with Training Log

[emteal]

I'm working on a training log project and after hours of searching google I came across this forum which has been helpful and confusing at the same time.
I'm using Excel 2007.

I have three spreadsheets so far reflecting:Training Log (which I want to be the master overview), Course Listings, & Personnel Info

On the Training Log Overview I would like the following to populate:
Date of Training
The Name of the employee (from Personnel Info Spreadsheet)
The Course (from Course Listings Spreadsheet)
The Instructor (from Course Listings Spreadsheet)
Whether the course has been taken (Yes, No-Training Log Project Help.xlsxFuture) (so that I may enter all new hires as NO until I receive their training certificates later on)
Expiration Dates (as some courses are required annually or must be renewed based off dates)
Hours Completed for the year per person (as 20 hours are needed annually- Not sure if another spreadsheet that tracks hours for the year would be needed to capture this information by itself)

The important thing is that I need a place that logs who did what and when so that I may send email reminders for expiration dates and keep track of hours completed for the year.
Could someone please help as I'm pulling my hair out!

[emteal]

Training Log Project Help.xlsx
Attachment- Sorry