如何通过将文件名与列名匹配来提取数据

It should be easy but I am not able to do it. I have many files and each file is named by species name. I also have a data frame in which each column is named with the species names. I just want to extract the column from data frame and combine that column with the respective species files after changing the column name to let say, 'Common' probably in a loop, so that later on colud compare all the species. It should be easy but I am not able to do it. I