Transforming Workbook One By One
There is an Excel file that teaches how to perform the Transforming Workbook One By One operation.
Excel Professional Transforming Workbook One By One
This workbook demonstrates transforming workbook one by one using VBA macros on a 1-row data layout.
Hope it is useful.