将多个.xls文件添加到单个.xls文件，使用文件名命名选项卡

I have multiple directories, each of which containing any number of .xls files. I'd like to take the files in any given directory and combine them into one .xls file, using the file names as the tab names. For example if there are the files NAME.xls, AGE.xls, LOCATION.xls, I'd like to combine them into a new file with the data from NAME.xls on a tab called NAME, the data from AGE.xls on a tab called AGE and so on. Each source .xls file only has one column of data with no headers. This is what I have so far, and well it's not working. Any help would be greatly appreciated (I'm fairly new to Python and I've never had to do anything like this before).I have multiple directories, each of which cont