Find out all sheetnames for each workbook in a folder WITHOUT OPENING EACH
WORKBOOK? (I'd like to have them in a column on my worksheet for further
processing.)

Similarly, can I copy data from one workbook to another (or for that matter
from within a workbook) WITHOUT OPENING EACH WORKBOOK?

I ask cause the opening and closing seems to take up rather a lot of time...

Many thanks for your answers.

Regards,
JVLIN