Thanks for sharing.

I think for this particular case an alternative to consider also is the use of pandas to read each sheet and workbook as a whole and then merge the resulting dataframes prior to exporting back into Excel format.