I really hope someone can help me with this.

I have a table with a set of names and ids. What i need to do across multiple sheets is to find the cell that has any name from that table and in the adjacent cell to its left, insert a vlookup formula to find the respective id.

Many thanks in advance.