Is it possible to load excel data from other excel sheets?

Question

excel

The question arose, is it possible somehow to load data from other sheets into a specific sheet?
Those. there are tables in which it is necessary to select the necessary rows using functions and filters.
And I want to make it as the resulting file into which data is loaded from external files and all these functions and filters are applied. Such a mini-dashboard))
Tell me - is this possible and how to implement it:?

Answer 1

Perhaps with macros or file linking or through a data connection,
linking allows you to link to another workbook in a formula in a cell.
Data connection (Data menu) allows you to pull data from other sources (source types are defined)
Macros allow ALL

Answer 2

PowerQuery is what you need. https://www.youtube.com/watch?v=fxaGDET2lhs