empty_wb = xl.Workbooks.Open(util.getTestRessourcePath('emptyWorkbook.xlsx'))
tocopy_wb = xl.Workbooks.Open(util.getTestRessourcePath('toCopy.xls'))
tocopy_wb.Sheets(1).Cells.Copy()
empty_wb.Sheets(1).Paste(empty_wb.Sheets(1).Range('A1'))
How to merge several Excel sheets from different files into one file