Excel Auto Sort and Auto Summarize [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 3 days ago.

I tried the following code and I can't seem to get things to work...

I am needing help to 1) Auto Sort and then 2) Auto Summarize "like-with-like" based on the following column criteria. . .

A few things about this list. . . -I need the item list to sort by alphabetical order -Then I need "like" items and quantities to be summarized. -If there is something I type in the NOTE column I need those quantities to be listed separate (Ex: the item LUS26 in the AFTER picture below) -Also, I need this Auto Sort/Auto Summarizing function to ONLY occur from rows 8 through 34 (but if I add additional rows between rows 8-34 I'll need these ADDED rows to be part of the Auto Sort/Auto Summarizing function). Example, if I add 5 rows then I'll need it to run the function between rows 8-39.

BEFORE

AFTER