merging multiple files

I

ILXCEL

Is there a way to merge multiple files where the worksheets have the same
name without manually opening every worksheet?
 
Top