title: Excel VBA - Pull data from external books and paste into the next blank row in multiple tabs
body: <p>I'm working on automating a workbook in Excel, and I'm running into a few issues with my VBA code. I'd paste it here, but I've been through so many iterations, it's pretty unusable. </p>
  
  <p>The goal is to have the active book 'grab' the data out of several workbooks containing raw data when it is opened, and put the copied data into a few tabs that can be used to populate various charts on a dashboard tab. Each workbook containing raw data should go into its own separate tab within the active workbook. Broken into steps, I am thinking I need the below process to occur:</p>
  
  <ul>
  <li>Open Active Book</li>
  <li>Open hidden tab 'Sheet1'</li>
  <li>Open raw data book 1(e.g. c:\Raw Data.xls)</li>
  <li>Copy data from specified location (e.g. [Raw Data.xls]Sheet1!$A$3:$AE$64) in the raw data book 1</li>
  <li>Paste copied data into Active Book, into specific worksheet, into first empty row (e.g. [Active Book.xls]Sheet1!<strong>first empty row</strong>)</li>
  <li>Hide tab 'Sheet1' in Active Book</li>
  <li>Close raw data book 1</li>
  <li>Repeat process using raw data book 2 and sheet2 of Active Book</li>
  <li>Repeat process using raw data book 3 and sheet3 of Active Book</li>
  <li>Only after data is populated into the destination tabs (Sheet1, Sheet2, Sheet3 in the Active Book), can the user interact (click into cells, change tabs, etc) with the workbook</li>
  </ul>
  
  <p>I know this is simple - I'm getting frustrated, as I'm a newbie and the syntax (and multiple variations of syntax) is really throwing me for a loop. Any help would be greatly appreciated. Many thanks in advance!!</p>