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).