Hello. My name is ***** ***** is a function referred to as Importrange in google sheets that performs this.
I can help you get started with a few examples if you would like.
I'll just need to see your spreadsheet as it stands now so I can give you the proper guidance.
If you would like, you can link to it in this chat, so I can view it. This will at least get the ball rolling.
I would have to get a look at your spreadsheet and familiarize myself with the layout so I can assist you.
If I am on the wrong track here, I apologize.
I can opt out for another expert that may use a different approach.