Precise file Link below :-

https://www.mediafire.com/file/1gowtv45o9g61dt/Combine+Sheets+&+Files.rar/file

Method -1

👉Copy Paste

Method -2

👉VSTACK Formula :-

VSTACK uses the dynamic array environment to combine lists and arrays vertically into a single array. It has no complicated arguments or formats.

Method -3

👉Using VBA Code

Video Link :