making multiple sheets into one master list

kivaconnor There are several ways to merge table data as your request.

1st Method 

1.Try excel extended tools such as [Kutools for Excel: Powerful Excel Toolbox](https://www.extendoffice.com/product/kutools-for-excel/product-tutorials.html). In this https://www.extendoffice.com/documents/excel/456-combine-multiple-workbooks.html kutools provide at least three ways to get the master list.

• Easily Combine Multiple Workbooks Or Specified Sheets Of Workbooks To One Workbook
• Combine Multiple Workbooks Or Specified Sheets Of Workbooks To A Master Workbook With VBA
• Combine Multiple Workbooks Into One Workbook With Move Or Copy Function

In your case, I think the easy combine could work well for you.

2nd Method

2. Try other office application such as https://www.wps.com/mac/. I use WPS to get master list from merging table data in just four steps. I put my steps in images as below, hope it helped.

Step1.

Open WPS software

Step2.

Open workbook which contains multipule worksheets which ready to be merged.Mine contains three sheets with same title row.

sheet1:Alice

sheet2:Bob

sheet3:Cindy

Step3. Use toolbox to merge table.Click toolbox on the top bar. Click Merge Tables. Click Merge worksheets. 

Step 4. Select worksheets needed to be merged. Select title row for 1 which is quite important. Select :art mergin.You may take a look at the snapshot when I make my selection.

Master List