Looking for a way to consolidate account list from multiple tabs in a worksheet

I have a spreadsheet where I am trying to consolidate certain information from multiple tabs in a way that people who are not necesarily savvy in excel will be able to perform the task. There is a master tab on which I need to pull 3 columns of data from 7 tabs in the worksheet. Currently I am using a pivot table for each sheet and then copying that into the master list. I am using a pivot table since the 7 tabs will have duplicates in the contract listing since there will be multiple entries for each contract. Basically im trying to find if there is a way to write a macro that would perform the same function as a pivot table except cumulatively on all 7 tabs. Any help or input is greatly appreciated. I have attached a sample worksheet with 5 sample entries in each tab instead of the 4000+ entries that are actually in my worksheet.