Export Data From one source to multiple destination"Destination not in the same format"

In one fixed location , I have one file called x
in x file there are 50 rows (this 50 is changeable in each case and it depends on the last row)
the first column in the x file has a unique code (it might be from 30 to 80 but let us assume it in this time from 1 to 50)

in another fixed location , i have some files counted with the same count of the rows in the x file (in this case it should be 50 files)
the 50 files are not in the same format (they are 6 different format)
the last digit of the name of each file from the 50 files is one of the unique numbers in the first column in X file

For example
in X file
Coumn A Column B
1 pp
2 nn

and the name of the files is A1 and A2


What i need is export the data in column B in X file to each file from the 50 files in specific cell (the destination cell varies in each format of the six format)


thank you in advance ,i really appreciate if someone can help me