I have an excel file set up and formatted the way I would like it to print, and in this file I have a number of cells with unchanging reference codes.

Every week, I get a folder of one or two line text documents that match up to the reference codes. I would like to automate the process of moving the new text into the cells of my worksheet.

An example:

The cell containing reference code T76 needs to be filled with the contents of t76.txt, and the cell containing the reference code n158 needs to be filled with the contents of n158.txt etc..etc..

It seems like an easy task and I am willing to learn how to do it myself, but I am not sure where to start

Thanks,
Alice