How to unify several excel books into one?

Hello,

You can watch the YouTube video in the link below on how to combine multiple workbooks into one

https://youtube.com/watch?v=JiAYngRcN0s