Hi,

I'm new to the forum and also new to VBA in excel. Im familiar with excel but I now need to improve my skill with VBA for my career. My name is Sylvain, im 26 years old. Im from Canada.

What I need is to copy 1, 2 or 3 sheets from 4 differents .xlsx to one new sheet. To do that, I used Ron's de Bruin Excel Tips.

Here my code so far :
Please Login or Register  to view this content.
I would like to copy different sheet name from all files in the folder. I been trying few things to make this working but Im having some trouble with this. This code is working but only for the first sheet of each .xlsx.

Can anyone help me with this? I need help!

I appreciate any help you guys could give me.

Thank you!