I am working on a macro that will allow me to select the folder these files are contained in and will then will loop through that folder and pull the necessary data out of the excel files and combine all of that into one master worksheet. I have many excel files, contained in a single folder, that all contain the same type of data in the same columns with varying amounts of rows in each.
