Real Estate Lead Management How Do I Merge Multiple Excel Worksheets Into One Master Sheet That Updates?

How do I merge multiple Excel worksheets into one Master sheet that updates? - real estate lead management

I have a program for the players in my Real Estate Office. This is a program management lead. It has 5 worksheets, one for each type of customer. 6. I want a file containing all the names of 5 different matter. I want to be the "master" sheet to update automatically when a new runway is added or changed. HELP!