vba code to extract specific data from 2 worksheets to 1 mastersheet

[antz74]

need code on how to extract specific dates from 2 worksheets to 1 mastersheet.
the dates need to go into mastersheet and be placed in cell which corresponds with the correct name and course that it originated from if that makes sense

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...a-2-worksheets-1-mastersheet.html#post5111655

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.