(VBA) How Assign Column Cell To Corresponding Group, and Paste Group Cells into Groups WS?

Trying to write a VBA script for this, kind of confusing to explain, but here is the question:

(Link to workbook)

How do I group each list of Keywords into it's corresponding Group's worksheet, using VBA code?

Approach tried: I tried using a dictionary object, but couldn't wrap my head around it nor get it to work. To me it seemed like a decent solution, but I don't really know where to start on this script.


I have a list of Keywords in Column B, and each Keyword corresponds to a Group in Column A:

bjfzpe.jpg



Examples of Keywords corresponding to their respective Groups (worksheets), copied to Groups "Stainless Steel" and "Glass Dispenser":
Note: Keywords will be copied into Column A for each respective Group (worksheet)

Group (worksheet) "Stainless Steel":
mhspah.jpg

Group (worksheet) "Glass Dispenser":
111qow4.jpg


Any hints on where to start with the code / sample code suggestions? Any help would be greatly appreciated!