Combining sheets into a master file

Hello
I am brand new to this forum and am hoping someone here can assist me. I have been asked to combine four separate sheets in Excel into a "master" sheet that can automatically increase in size to accommodate changes to the four sheets. In other words, each separate sheet represents a single account manager's clients. They add and update their individual sheets as changes occur. These lists and changes are fed into the "master" sheet so that it has a complete list of all items in each of the four separate tabs. As new rows are added to these account manager tabs, the changes are also reflected on the "master" sheet. The Concat field is a unique identifier that we utilize to reference individual records. My initial thought was to use these Concat identifiers somehow to identify and recognize changed conditions within each account manager tab but am not fixed on doing that. I really just need a way to have a dynamic master sheet that reflects any changes made to the account manager tabs. I've attached a sample file as well.

Happy to provide further clarification if my explanation doesn't make enough sense.

Thank you to all who provide any assistance at all.

Have an excellent day
Calextest.xlsx

with Power Query

Hi Sandy666
Cool! Is there a way to make the Power Query table update automatically every time a new record is added to the other sheets (or gets deleted)?

sure, make changes then go to green table, right click on this table and hit Refresh then you will see changes in master table