"I want to be able to open each respective file in cells I11:I27".
What is the full path to the folder where the above files reside?
Are there multiple worksheets in each workbook?
Or, do you want to copy only one worksheet?
If you want to copy only one worksheet, what is the sheetname? And, what is the range to copy?
Have a great day,