Into cell B2 of your final table enter the formula
Code:
=IIF(SUMIFS(SourceDateRange, SourceNameRange, $A2, SourceCourseRange, B$1)=0,"",SUMIFS(SourceDateRange, SourceNameRange, $A2, SourceCourseRange, B$1))
, where all 3 dateranges are of same dimension, and defined using absolute references (like SourceSheet!$A$2500 for SourceNameRange, and SourceSheet!$B$2500 for SourceCourseRange, etc.).
Copy the formula to whole datarange of your final table! And format the datarange there as date!