title: Reference multiple sheets in one line
body: <p>I was wondering if there is a way to reference multiple sheets in a single line in Excel VBA. I know you are able to reference multiple ranges, columns, rows via:</p>
  
  <pre><code>Range("G1:G5, G6:G10, H5:H10") etc...
  </code></pre>
  
  <p>I want to be able to do the same thing with sheets I tried this:</p>
  
  <pre><code>Sheets("Sheet1_Name, Sheet2_Name, Sheet3_Name").Range(...)
  </code></pre>
  
  <p>But that didn’t work so I was wondering if there was a special way to do this aside from putting the sheet names into variables then referencing the variables.</p>