Open file in folder and copy data to another file

Hi,

can anyone please help with the following. I'm trying to creat a macro that will open every file in a specified folder copy a specifc range to another sheet (the sheet with the macro in) and close the file and keep looping through every workbook in the folder until all have the range copied. It also has to ensure that when it copies the range from one workbook, it doesn't overwrite what has already been copied from another workbook in the folder

is this possible

many thanks in advance

Hi
What are the sheet names and the range you wish to copy?
Ravi