So you are saying you have a lookup sheet in a destination workbook, and for each file path given in the lookup sheet (probably in a single column), these workbooks need to be opened, the data in the first sheet be filtered for last, current and next week, and then copy the filtered data in B6:N999 and paste it in some destination sheet of the destination workbook.