Is there a way I can copy the same range of 20 rows from 6 specific columns out of 700 workbooks into one workbook each week.
