Interesting start. I also took the loop approach. I had to install and import xlrd and openpyxl for it to execute properly.

The combined spreadsheet was all scrambled; no way to tell what information came from what file.