another possibility is to delete the empty cells in front of the first file, after the second file is imported
try like
Code:
range("a1:g" & x).Delete xlshifttoleft