Merging Different Workbooks (not shared)

I have 21 excel workbooks, some have up to 100 worksheets inside.

I'd like to merge them all into one big doc. Can this be done?

I have looked around but only found how to merge shared workbooks.

Every worksheet has a common theme where they all have information that starts on line 1, 50 & 100.

Thanks