Need to search between worksheets and consolidate on separate sheet.

I have 4 pages in my workbook. Page 1 has names and Prices. Sheets 1-3 have stats I need to search by name and add to the first page. So each player with price on the first page would have three stat numbers in an Excel table. Thank You. B.

AttachmentSize
OCT22.xlsx29.19 KB