Adding names from different cells to a consolidated list in one cell

As the topic describes I need to add names from different cells to a consolidated list in one single cell. This could be done easily with the "Concatenate" function. The problem is that the names are spread out over different cells in a spreadsheet.

The combining key factor is that all name end with /ABC.

So what I am trying to do is to write a piece of VBA code that searches all cells in a spreadsheet (or just from A1-Z200 would be more than enough), and makes a single text string in a single cell out of all values ending with /ABC.


Hope you can help.