Where are the source files located? If they are all in the same directory then you can loop through all the workbooks in that directory and copy from the desired sheets the range specified and paste into the new workbook.
Give this a try and see if it gives you the results you are after.
This will use the Current Directory as the source for the files to pull data from, and pulls data from the first sheet of each file found in the current directory and pastes it in the next avaliable colulmn in the workbook from which you are running the code.
If you need help with further modifications post back.
Bookmarks