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.

Hi! Fantastic work - many thanks. Just one simple thing - is this possible that Name, Current Role and Site appears on every line not just in the first one for courses of the same person? This is needed for filtering purpose.
Many thanks again!