I have different excel files in the same folder
Just do what Recessive said and use a for loop to read the excel file one by one and do the following:

excel_files = os.listdir(filepath)


for file in excel_files:

read excel file sheet




save specific column to variable




end of loop



concatenate each column from different variables to one dataframe
I have different excel files in the same folder, in each of them there are the same sheets. I need to select the last sheet of each file and join them all by the columns (that is, form a single table). The columns of all files are named the same. I think it is to identify the dataframe of each file and then paste them. But I do not know how