title: How to copy ALL data from 12 workbooks onto a blank one / Range Inquiry
body: <p>I am almost completely new to using VBA and Macros on Excel 2010.  I know little to nothing about macro coding, and I just started a day ago trying to pick it up.</p>
  
  <p>I was asked to create a macro that copies ONLY the data from 12 workbooks and pastes it onto a blank workbook (<strong>they all have 1 sheet each, with the data on each workbook starting on cell A3 while stretching to column S (the amount of data on the sheets vary)</strong>).</p>
  
  <pre><code>   NOTE: When I mean "ONLY the data," the cells that I want to be copied include the blank cells that are in between the first and last parts of the data.
  </code></pre>
  
  <p>1) When copying data from one workbook to another, do you HAVE to specify the cells that you would like to copy?  Or is there a way to specify where the data ends on the sheet, and then copy all of that data?  If so, then could someone show me how to do so?  The reason for doing so is because the macro will be used weekly.  </p>
  
  <p>and 2) Could someone simply help me develop this macro? Help would be massively appreciated :)</p>
  
  <pre><code>   Some Extra Notes:
     - The Workbooks are named "Status by offering ID [1-12]
  </code></pre>
  
  <p>Thanks again!</p>