Excel VBA:查找数据，循环多个工作表，复制特定的单元格范围

I am creating a macro for a file that will be distributed to a team of people; the function is supposed to be able to pull the person's name from a different cell (in Variable B), search for that value in another workbook with multiple sheets (Variable X), and if found copy a specific range of cells from Workbook X to Workbook B.I am creating a macro for a file that will be d