Macro novice look for support - tricky:-)

Hi all, I am very novice to Macro programming (in fact I most of the time only record them an only make some changes in the macro itself :-)
but now, macro recording is not sufficient anymore to solve the following problem:

I have in the same workbook:
Worksheet A with a list of trainings names in cells A2 to A45
Worksheet B with a list of names in cells C2 to C250
Worksheet C listing training completion (only listed if the training was done) with
training names in column A, Completion date in column B, Names in column C
Worksheet D, with a Matrix showing per Name/Training if YES/NO the training is required for this person

I want to do the following:
in worksheet B, for all names, starting Cell E2
check in Worksheet D if the training is required for each person-
if no - display " not required"
if yes, check in Worksheet C if a training completion date is listed for this person
if listed - display the completion date from Worksheet C
if not listed - display "missing record"

I have no idea if something like this is possible - and I would be very grateful for any kind of support!
I attach an example of the workbook for better understanding.

If it is not clear please post a reply with your questions!THANKS A LOT FOR YOUR HELP!

Forum Rules

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.