title: vba code to insert dynamic amt of rows
body: <p>need to modify this code which currently pastes the current region to the specified page, to instead read the # of rows used on the sheet that is called, and then insert that number of rows before pasting the data. having issues if the sheet called is > 187 rows it will paste over existing data that it should not touch. need it to then reset when a new sheet is called to the pasting area</p>
  
  <pre><code>    Dim wkSht As Worksheet
  
  For Each wkSht In Sheets
  'sheet6 is the DashboardMain sheet
  
      If Sheet6.Range("E3").Value = wkSht.Name Then
      wkSht.Range("A1").CurrentRegion.Copy Destination:=Sheet6.Range("A12")
  
      End If
  
  
  Next
  </code></pre>