title: Tables from multiple files to one variant Array
body: <p>I'm writing a process and using a while-loop to go through through all folders and excel files in a user specified directory.  </p>
  
  <p>My question is, I want to pull a certain set of data from each workbook and add them to one large array that I can perform calculations on after I have all my data grouped together in one array.  Would rather not dump all of this data to excel and calculate as it could be many thousands of rows.  </p>
  
  <p>I'm not sure how to amend the size of the array without deleting old data?</p>
  
  <p>Any help is appreciated!</p>
  
  <p>Thanks!
  Ryan</p>