将Excel.WorkSheets转换为相同的Excel.Workbook

So, after much researching and using code below in a Class the items I'm passing (a DataTable) open up in Excel. I have around 5 sheets that need to open in the same book. The code below is for the first 2. The problem is they are all opening in NEW WorkBooks -- I need them all to open in the SAME WorkBook. They are opening on the correct sheet in each new Workbook though. I thought a simple "if" statement would work, however, it is not-- Any input on how to get them consolidated into one WorkBook would be greatly appreciated and thanks in advance!So, after much researching and using code below