Excel formula to auto -populate data from a raw file

Good day everyone, I'm just a newbie here and don't know much about the excel formula. Any advise, tips and tricks regarding to how to auto-populate a certain cell with same name but also have diffe...