title: Copy multiple rows and columns from multiple tables into one table Excel
body: <p>I need to copy multiple rows and columns from multiple tables into one table, but I'm not sure how to go about doing this. All tables have the same header (same variables).</p>
  
  <p>My case:</p>
  
  <ul>
  <li>Table 1 is the main table I want to populate.</li>
  <li>Table 2 has 20 rows (constantly growing) with 50 columns (constantly growing).</li>
  <li>Table 3 has 50 rows (constantly growing) with 50 columns (constantly growing).</li>
  <li>Table 4 has 100 rows (constantly growing) with 50 columns (constantly growing).</li>
  <li>Table 5 has 250 rows (constantly growing) with 50 columns (constantly growing).</li>
  </ul>
  
  <p>For table 1, I would like to copy each of the rows from the other tables into it. </p>
  
  <p>Example: I would like all of the rows from table 2 copied to table 1, then right underneath table 2's data copy all of the rows from table 3 to table 1, etc. </p>
  
  <p>If possible I would also like to be able to specify which columns are copied. The columns copied will be the same on all of them. </p>
  
  <p>Example: I want to copy columns A, B, and D, but not C from each of the tables to table 1.</p>