Consolidation of information with power query

Hello, I have an excel file of work with several sheets (Book 1) and I will continue adding more in future weeks, in another folder I have a book for reports (Book 2). I need to consolidate the information in book 1 in book 2. I will be attentive to your help.

Greetings from Peru.