title: Running my macro on all worksheets
body: <p>I have to prepare a short Macro.
  I multiple worksheets in a workbook and I wrote a macro to import a range from a different workbook, but I want my macro to loop over all worksheets.
  I read a lot about it but still I think I am missing some basic knowledge on <a href="/questions/tagged/vba" class="post-tag" title="show questions tagged 'vba'" rel="tag">vba</a>.
  Could someone please help me to put this macro in a loop?</p>
  
  <pre><code>Sub AddHeader()
      current = ActiveWorkbook.Name
      Range("A1:C96").Select
      Selection.Cut Destination:=Range("A55:C150")
      Windows("MIP_Ordering_Header.xlsx").Activate
      Range("A1:H54").Select
      Selection.Copy
      Windows(current).Activate
      Range("A1").Select
      Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
      SkipBlanks:=False, Transpose:=False
      ActiveSheet.Paste
      Cells(53, 1).Value2 = "Plate Name:" &amp; ActiveSheet.Name
  End Sub
  </code></pre>