How to set up a loop to let different excel sheets merge together?

when I’m trying to set up a loop for merging different excel sheet together, i’m not sure I need to use look up range first, then build data table and merge. But I can only merge 2 excel sheets once but not generating a loop automatically.

Hi @chenyyalex,

Take a look at this.

Regards
Balamurugan.S