Index Multiple tables on multiple sheets

Hi, so I have a problem. I have a sheet with Cases that differ by Teams. Each team has has their own Excel Sheet. So when an entry is put into one of the sheets, I want it to show up on the main sheet "SM June". I can do a regular INDEX and Match such as =INDEX(Table9[Case Driver], MATCH([Case Number],Table9[Case Number],0)), but I want to Index two tables and match on that one sheet.