Summarize data from multiple worksheets

Hi all excel experts,

I am in process of preparing training records file but unfortunately I get stucked.
My file will contain about 50 worksheets - one for each of the employees named as employee name (every worksheet will be the same format).
What I will need is a macro which will pull out data from individual training record sheets into the summary sheet.
Sounds simple but is not simple for me - I hope somebody will help me with that.
I have uploaded sample workbook so it will be easier for somebody who will decide to give it a try.

Thanks in advance for any help.