Copy Find All Dialogue Box

About a week ago I found the solution to my goal (weeks of on and off searching) from this forum site however, the VBA code didn't work on my computer. I intend to post it here later since I don't have access to it now and can't find it. For now though, here is my question:

I need to "find all" of a specific word and produce a copy of that "find all" list. More specifically, I want a list of the cell names (Sheet1!A1, Sheet2!B52, Sheet3!C20, for example) where my search criteria is located. So if I'm looking for the word "Pizza" and it's found in those cells, I want to copy that whole list for multiple worksheets (each worksheet ranging from A1 through Z3000; gaining rows as the file is updated).

I have extremely limited VBA experience and am now reading books to understand it more. When I post the code, I'd also like to know how to fix it too.

Thx in advance.

MsBBStacker