Add Quantity of Redundant Rows, then Delete Redundant Rows

Hi All!

I'm trying to combine multiple lists of things people want (such as multiple grocery lists of items and their quantities). I'd like to create a vba code that sorts the lists from A-Z (to get the redundant items next to one another), add the quantities of the items, then delete the redundant rows.

For example:

Person A wants:

Item	QTY
Apple	2
Bananas	2
Oranges	2

Person B wants:

Item	QTY
Apple	1
Bananas	3
Oranges	1
Pineapples	2

And want my list to end up like this:

Item	QTY
Apple	3
Bananas	5
Oranges	3
Pineapples	2

Noting that the order may not always be alphabetical and the number or type of items they want may not be the same either.

If there's a more succinct way of accomplishing my same goal I'm all ears! I appreciate all your guys' help in advance! Thanks!