Update pptx file with data from excel file

Hello All,

I would like to request your help in regards to the below:

I have an pptx report with a standard format. It's include some data in a text box and charts that should be extracted and updated from an excel file each time when I am opening the pptx file.

In other words I would like to set up for each slide to take the value from cell B2 sheet1 /for example/ and update the value in text box 1 in slide 2, next take the value from the C2 sheet 2 from the excel file and update the tex box 2 in the in the slide 2. and etc.
Also, link the range ("A1:G3") of the sheet 4 to the chart on slide 4 and update the values when the pptx is opened

All the action should be configured in the pptx VBA not from the excel file, as the excel file will be automated exported each time.

I will really appropriate if somebody can help me.

thank you very very much in advance for your time.

Valentina