title: How to create an Excel Sheet and Add it to Multiple WorkBooks in Excel InterOp
body: <p>I've been following the following pattern to create multiple sheets and multiple workbooks using Excel InterOp. Now, I would need to create a let's call a master workbook which would contain some of the sheets out of the sheets that I've been creating in the original workbooks. Just to give an example, let say WorkBook1 had Sheet1 and Sheet2, and Workbook2 had sheet3 and sheet4. I want the Master workbook to have Sheet1 and Sheet3. I'm looking for a way to create the sheets (sheet1, sheet2, sheet3, sheet4) that I've been creating for WorkBook1 and WorkBook2, but also with minimal amount of code repetition add sheet1 and sheet3 to the Master workbook. Any help will be appreciated.</p>
  
  <pre><code>For i = 1 To 10
     Dim xlApp As Application = New Application
     Dim xlWorkBook As Workbook
     xlWorkBook = xlApp.Workbooks.Add
     Dim xlWorkSheet As Worksheet
     Dim xlSheets As Sheets = xlWorkBook.Sheets
     Dim xlNewSheet As Worksheet
     Dim sheetCount As Integer = 1
  
     ' So I repeat the following block to add multiple sheets with different content to a WorkBook
     xlNewSheet = xlSheets.Add(xlSheets(sheetCount), Type.Missing, Type.Missing, Type.Missing)
     sheetCount += 1
     xlNewSheet.Name = SomeName
     xlWorkSheet = xlWorkBook.Sheets(SomeName)
     AddContentToSheet(xlNewSheet) ' A Sub that adds real content to the sheet
     .
     .
     .
     .
  
     xlWorkBook.SaveAs(...)
     xlWorkBook.Close()
     xlApp.Quit()
  Next i
  </code></pre>
  
  <p>So now, my question is, if I have my Master Workbook:</p>
  
  <pre><code>Dim MasterWorkBook As Workbook
  MasterWorkBook = xlApp.Workbooks.Add
  </code></pre>
  
  <p>defined before the loop that repeats 10 times to create 10 different WorkBooks. How can I add select Sheets to MasterWorkBook with minimal amount of code repetition. </p>