How to link separate Excel files to auto-populate cells

Originally Posted by jindon

I don't understand about formula etc.

Thanks Jindon,

The demo works well. My question regarding the formula is that I don't know how to apply this to my actual data. What formula do I enter and where to achieve these results with my data and as a I create new data sheets.