copying data from multiple workbooks into another

Hi,

I am a novice in writing macros.
I need to copy data from only the first sheet of multiple workbooks whose path are given in the look up sheet of destination workbook.
The macro should run in a way that it opens each file from the paths provided in subsequent rows, autofilter the date columns based on lastweek, thisweek and nextweek, and copy the range B6:N999 from each sheet and paste it in the first sheet of activeworkbook(destination workbook).

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.