JJ,
The display of your example data got really messed up, to make sure we give
you a good solution could you repost and give the example something like this:

Worksheet A
[A] [b] [C]
1 PL001 SP001 DL001

Worksheet B
[A] [b]
1 PL001 5
2 DL001 8

But based on those layouts, we could use SUMPRODUCT() on sheet A to give
combined quantity for each item. In A2 use a formula like this:
=SUMPRODUCT(--('Worksheet B'!$A$1:$A$1000=A$1), ('Worsheet B'!$A$1:$A$1000))
Fill the formula across the sheet.
Actually, in this case, you could even use the simpler SUMIF() formula
because there is only one thing to match (the item ID):
=SUMIF('Worksheet B'!$A$2:$A$1000,$A$1,'Worksheet B'!$B$2:$B$1000)

If Worksheet A is laid out like:
[A] [b]
1 PL001 formula
2 SP001
3 DL001
Then in B1 the SUMIF() formula would be
=SUMIF('Worksheet B'!$A$1:$A$1000,$A1,'Worksheet B'!$B$1:$B$1000)


"JJ" wrote:

My next problem is I need to extract only certain information from a
worksheet as sample-

Worksheet A Worksheet B
Column A Column A Column B
Column C

SP001 SP001 PL001
16
SP001
PL002 1
SP001
DC001 5

Worksheet B is my Bill of Material but I only want to extract only certain
info such as PL001 / PL002 with the qty's.

Any assistance is appreciated.