I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that
are in the same folder into 1 spreadsheet in a separate workbook.I want to
insert a new row for the data from every workbook. All of the workbooks have
the exact same format. Anyone know the easiest way to get this info compiled?