EXCEL SHEET SHARING

I AM STILL A BEGINNER/INTERMEDIATE EXCEL USER AND AM ATTEMPTING TO CREATE A "MASTER TRACKING SHEET" OF JOBS FROM MULTIPLE SHEETS(SALES PEOPLE). ALL 4 SHEETS ARE THE SAME WITH THE EXCEPTION OF THE SAL...