I have code written right now such that I am extracting and consolidating data from multiple files into a new workbook. Each file that is being extracted from has a different number of rows filled with data. How can I write a code so that it loops through each of the original files, finds the last cell with data in it, and copies that array?