I loop source files, open the file and the only worksheet, get the source range as worksheet use range, setup subsequent destination range, and add it to destination workbook and save it.

I loop source files
open file and the only worksheet
get the source range as worksheet use range
setup subsequent destination range
and add it to destination qorkbook and save it