Separate Text in A Single Cell & Count and Eliminate Duplicates

Hi,

Please see attached. I have a bit of an ambitious project. We are doing a lot of analysis of competing products, and I need to be able to look for identical ingredients in those products. I am looking to figure out which ingredients are predominantly used and to what magnitude. Hopefully I can do this with minimum syntax adjustment (i.e., paste and hit a button).

Ideally I'd like to be able to paste ingredients of products into a single cell in the "Input" tab, as I have in K3 etc. Then I'd like to be able to have a macro controlled by a button that would take the ingredients in single cell list form and (please see "output" sheet for examples):

1) separate each ingredient into an individual cell on the next "output" sheet (probably using comma separated values and delete the extra space after comma)
2) Eliminate duplicate ingredients (perfect match)
3) Deliver a count of the matches by each ingredient category and total ("all") (only if applicable)
4) Show a proportion of the # of ingredient matches by product category (Note: "All" on the "output" sheet is synonymous with "Total" or "Sum", meaning "Total of All Categories")

Is this even possible? Please let me know either way or if I can be clearer; thank you very much in advance for all of your help. I can't tell you how much I appreciate it!!

Best,

Clay