update cell with substring of another cell in another sheet

Dear,

Could anyone help me out? I have no clue how to write the correct vba code for this;


my sheet "overview" needs to be updated in cell C7 needs to be updated with the following logic:

-loop through other sheets
-find in cell A3 value "Created on"
-if found then update sheet "overview" with substring of A3 starting from position 11 until the value "AM" or "PM"
- if not found : exit


Thanks in advance,

Rickmeister