How to make a worksheet with keywords from other sheets

[lyssarincessa]

I'm trying to make a list of keywords so every time I type a keyword or phrase into one cell, it will autofill into another "summary" worksheet so I can find all the keywords I've used and where they show up/how many times they've been used so I can see trends. Using "Concatenate" doesn't work because there's no commas.