Hi, I know you are searching VBA Code here. But I want to share a simple tool which can help you to merge multiple Workbooks without writing any single code.
Check it out: https://www.synkronizer.com/compare-...features/merge

Cheers!