根据文件名将多个.xlsx文件从目录读取到单独的Pandas数据帧中

I want to load multiple xlsx files with varying structures from a directory and assign these their own data frame based on the file name. I have 30+ files with differing structures but for brevity please consider the following:I want to load multiple xlsx files with varying