DDE Cells in a master workbook from cells in another workbook

[MalcomG1234]

Hi,

I have a MasterScore.xlsm. I wish to use DDE to get automatic updates from specific cells of other Workbooks.
DE_Score.xlsx, JB_Score.xlsx, BP_Score.xlsx.
I don't want to use ADODB or similar to read the data in, I need the data/updates to be dynamic or automatically synchronise with the master Workbook.

The Manual Operation I wish to Automate:
* In Excel, I would open a xx_Score.xlsx, activate shDATA sheet, then select A2, right click copy.

* Select MasterScore.xlsm, Activate mData sheet, select the desired destination cell and right click "Paste-Link"

='C:\Users\MG\Desktop\VBA-WIP\VBA\[DE_Score.xlsx]shData'!$A$2" - Would appear in my sheet and this creates the outcome I desire.

* Save the MasterScore.xlsm.
* Close the DE_Score.xlsx.

Therefore every time DE opens his "score .xlsx" and updates cell A2, it would immediately reflect in my Masterscore.xlsm.

What code or command can I use to create the "Paste-Link" style data into my MasterScore.xlsm, mdata, {cell} to avoid having to manually perform this task for a 100+ xx_Score.xlsx Workbooks. Can I simply write code in the MasterScore.xlsm which DDElinks the desired cells from the desired workbooks? Once I know the command I assume I'll be able to loop through the code to perform this for 100+ workbooks without having to manually interact with them, I just can't work out the VBA to achieve this - Paste-Link DDE bit.

Thank you, ever so much.