title: Transfer from one workbook to another workbook
body: <p>VBA Code to transfer from one workbook to another. For example I have a workbook with multiple sheets for each department. Once the items are completed I manually copy and paste to the completed workbook. I need help creating a VBA Code that will update only the completed items to the completed master workbook. I tried the following VBA code but it transfers all the worksheets to one worksheet and that is not what I am looking for. </p>
  
  <pre><code>Sub SummurizeSheets()
      Dim ws As Worksheet
      Application.ScreenUpdating = False
      Sheets("Sales").Activate
      For Each ws In Worksheets
          If ws.Name &lt;&gt; "Sales" Then
              ws.Range("A2:K45").Copy
              Worksheets("Sales").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial (xlPasteValues)
          End If
      Next ws
  End Sub
  </code></pre>
  
  <p>I need <em>Cell A2:I45</em> to copy the items that have been completed to a master workbook if cell I has <strong>completed</strong> on it. Hope this makes sense, otherwise I can attach the excel workbooks.
  So, I have 4 worksheets for each sales location. for example worksheet1 is Sales, then the other Sales2...ect...All worksheets contain the same data but different department areas edit each worksheet, this is why there are multiple worksheets. Once they are all completed by each department, I want those 4 worksheets to transfer to one worksheet in the completed workbook. </p>