Hi all,

I am having the same problem. I want to copy sheet1 from 20 closed workbooks.
I have the path in column A.

The sheets (of closed workbooks) need to be copied to this file in a specific sheet name that is already created.
The Sheet name is in Column B.

Is thiss possible?
It contains 20+ files with only ±20 rows of text.

Thank you