Help to find relevant data across multiple tabs of data. I think it is a index, match 3D formula

calof1 Here are the steps:

1. Save the file
2. Click Data, Get Data (your button might be named "New QUery), From File, From Workbook:
3. Click on the file name and then click Transform data:
   
4. I assumed the tabs we wantto include all have three-letter names. Click the Add column tab, Custom Culomn button:
   
5. Use this formula to calculate the # of characters in the tab name:
   
6. Click the filter button on the new column and select "Number filters", "Equals...":
   
7. Set it to 3:
   
8. Select the first two columns by control-clicking their headers and right-click. Select "Remove other columns":
   
9. Click the expander icon next to Data:
   
10. Keep all columns selected and OK the dialog.
11. Delete all columns you do not need
12. Remove the first 15 rows:
    
    
13. Click "Use first row as headers":
    
14. Rename first column back to "Name":
    
15. Click "Close and Load", Close and load to...:
    
16. Choose these settings:
    
17. Now you're ready to create a pivot table which looks like your current report:
18.