Workbook merging

[GI38]

Hi guys. I was wondering if someone could help me.

I have multiple workbooks that I need to merge. I did find code that would merge all the workbooks in a folder into one workbook.

However, I need to merge only specific workbooks together. I need to merge the workbook in Cell A2 with the workbook in Cell B2 and rename it with the name in Cell C2. Is this possible?

Much thanks!

[alansidman]

https://www.youtube.com/watch?v=sLW3NbeGDy8

[GI38]

Thanks for that! I'll look into it!