On click, find text, compare and return cell for every found match.

Hey guys,

I'm hoping to see if any of you are willing to help break this down for me and hopefully give me some suggestions on what's the best way to tackle this?

As example, we have a 'BOXES' sheet that looks like this, and we'd like to order 10 of each.

						
Group	Number					QUANTITY
Box	BOX1					10
Box	BOX2					10

This is our DATA sheet, and shows what is inside the boxes that has to be ordered.

BOX1	 Screwdriver	
BOX1	 Saw	
BOX1	 Hammer	
BOX2	 Shovel	
BOX2	 Drill	
BOX2	 Hammer

Now if a order button is pressed, i want to look in my BOXES sheet for what is being ordered, in this case 10x BOX1 and 10x BOX2. After this, it has to find BOX1 and BOX2 in my (A-column)DATA sheet, and for every match of BOX1 and BOX2, it has to copy the B cell to our order sheet, where it has to merge any duplicate items. I have attached a simple example file, in case the above wasn't clear.


I have honestly no idea where to start with my limited vba experience. Any suggestions/help is highly appreciated in order to get me on my way.

Thank you in advance,
-Nick