title: VBA - Source data from multiple sheets
body: <p>I am attempting to create a new chart using source data from multiple sheets.  The data will always be in the same column no matter the sheet.  However, I would like to select the data from <code>Range("F2", Range("F2").End(xlDown))</code> from each of the sheets following the permanent two sheets at the beginning.</p>
  
  <p>The sheets that I want data extracted from will be used as source data for a chart that will be created and deleted as new sheets are added, and the cycle will be repeated.</p>
  
  <p>So, for example, I would like it to grab data from sheets 3 to 52, or however many there are, from the range specified above so it becomes one cohesive source.  I am not sure if there is a nice way to do this without using a hidden sheet.  Thanks in advance.</p>
  
  <pre><code>Private Sub Locations()
  Set Build = Charts.Add(After = Worksheets("Report"))
      With Build
          .SetSourceData
          .ChartType = xlColumnClustered
      End With
  End Sub
  </code></pre>