Macro to identify text - create table w/text & page numbers

[Cray_Z]

I am looking for a macro that will search the active Word document for specific text
and creating a table listing the text and page number(s) that it is found on.

Searching for .text = "\(CCI*\)"

I would like the table to look similar to this:

CCI # Page #
CCI 000808 1, 3, 8
CCI 000805 3

I modified an acronym finding macro and have limited success. It currently identifies the text that I search for but only returns the data for the first occurrence in the document.

I also would like to create the table at the end of the document starting on a new page.

Any assistance will be greatly appreciated.