A macro to insert pictures into Powerpoint slide from Excel

Hi guys,

I need your help with my problem.

I have two files, one excel file that include a schedule for the whole year with 6 coloum (A Week, B Day, C Date, D Opening responsible, E Closing responsible, G Backup)
The second file is an powerpoint file that showing the current week schedule with pictures. I usually change the pictures manually every week.

I saw this artikel
https://ccm.net/forum/affich-269046-adding-a-loop-to-macro-to-insert-pictures

and i'm wondering if it's possible in some way to bring the picture into powerpoint slide inside smart object depending on which day it is and which name is in coloum D E G.

Thanks in advance for any help.