Ihave 4 sheet with similar kind of structure; leftmost column has the
product code and other columns have details (numbers) about those
products.

ProdID Qty
1/art-05-d 200
1/art-05-q 204
1/art-05-s 420

I need to get the qty value and pass it to another sheet to same row
with corresponding ProdID. I cannot paste the whole columns, since not
all of the sheets have same amount of products. So the question is how
can i use the prodID as a "primary key"

Help is greatly appreciated.