Look up or Match

TBH and IMHO your workbook is set up backwards. It would be better to have a master list with all the information and then have a 'reporting tab' or just use filtering to show the skills of a specific person. But lets assume this is out of your control because those tabs come from some other app or something. Assuming the tab names match the names in the list you can use INDIRECT to 'build' the link/address to look up but I don't recommend that. Assuming you can 'bracket' the list of tabs (i.e. have a starting tab name and an ending tab name) then you can create a 3D formula that can pull data from all the tabs and do a lookup using that data but is there a cell on each tab with that employee's name?
Can you share a sample of the workbook structure without personal info so we can see the structure and create appropriate formula? if you can't attach here then share a link to it in Onedrive, Sharepoint, or other online sharing site.