Insert a range of cells that match a criteria to be returned as a cell comment

[Wdiaz007]

Hello All,

i am trying to retrive a range of cells in another worksheet that fit a criteria, as a cell comment, and have it automatically refresh when the criteria changes...:

in The "Master Sheet"; for both the "New" & "Re-Established" Sections I would like to insert a Cell Comment in the "Est. Gals & "Gals" columns that lists all of the customers established on their respective dates in the following format:

Date - A/C - Name - Street - City - Est Gals

i have attached the Spreadsheet:

Thank you in advance for your help