Find cell with value from a column and insert formula in the cell to its left

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.

Hi Konata

Can you please attach an example of what you need?

Thanks

Originally Posted by konata

I uploaded an attachment to conceptualize it. What is needed is a macro that:
1. will run across all the sheets
2. find the cell that has any of the names from the table in sheet1 and
3. in its adjacent cell (colored in red) insert a vlookup formula that will put the respective id from the table.

The main problem is that the name is not in the same cell across different sheets :/

Can the names in the other sheets appear more then once on each sheet?

No, each sheet has only one unique name. Moreover, that name will also be part of the sheet name.