Google app script project (Automation)

We are currently seeking a Google Sheets expert to create a solution for compiling data into a master sheet from several subsidiary sheets within the same folder. The project entails developing a method for real-time data aggregation similar to the process described in this YouTube video: https://www.youtube.com/watch?v=goiXzg3Cgqw