Adding mulitple tables to data model from different workbooks

Is there a way to add tables from different workbooks to the same data model?

If they are in the same workbook, it doesn't really minimize the size of the workbook.

Thanks

If you add with Power Query yes.
Power Query can work with more data then Excel.

Thanks. Would you happen to have a link on how to do that. I've been looking online. Either thanks for putting me down this path

This video show the steps.

Consolidate Excel Sheets with Power Query