Index/Match issues

Okay so I've been working for a few days on a spreadsheet for work. I have to keep certain data in seperate workbooks for different supervisors but I need one main workbook that all of the data associates with.

First workbook is ids: Several different worksheets with different names and id's. They are in different areas and HAVE to be separated.
Second workbook is cust info: This is my main workbook. When I type in a name I'd like it to automatically pull the id from the first workbook by scanning through all of the different sheets to pull the correct one.

Workbook 1:

A1 B1 C1
ID1 (ID2) Name

Workbook 2:

A1 B1 C1
Name ???? (ID2)


I'm not concerned with ID2. Figuring the issue out with ID1 will solve ID2. Same issue.
I've gotten it to pull the correct result when I'm only using one of the worksheets and both workbooks, I just can't get it to return accurate results when searching through all of the worksheets
I've attached an example if that helps.

Any help will be greatly appreciated. Please and thank you.