title: Copying to a specific sheet: openpyxl - destination sheet ignored when using copy_worksheet
body: <p>Per this <a href="https://stackoverflow.com/a/37948636/1059398">answer</a> and <a href="https://openpyxl.readthedocs.io/en/2.5/tutorial.html" rel="nofollow noreferrer">these documents</a> I tried to specify a <code>source</code> and <code>target</code> sheet to write to, but when I do, the results are the same as if I hadn't specified a target:</p>
  
  <pre><code>from openpyxl import load_workbook 
  wb = load_workbook('MyFile.xlsx')
  ws = 'Sheet1'
  
  
  idx = book.index(ws)
  new_ws = 'Test'
  book.create_sheet(new_ws, idx+1)
  source = book[ws]
  target = book[new_ws]
  target = book.copy_worksheet(source)
  wb.save('Output.xlsx')
  </code></pre>
  
  <p>vs</p>
  
  <pre><code>source = book[ws]
  book.copy_worksheet(source)
  wb.save('Output.xlsx')
  </code></pre>
  
  <p>Both result in a new worksheet called <code>Sheet1 Copy</code> added to the end of the workbook. <strong>How to a copy a sheet into another empty sheet, or specific location within the workbook?</strong></p>