ExcelBanter - Random table of data - need to find every cell that contains specific data

What I am trying to accomplish is to create a new table for each two letter abbreviation found in the Variables tab. Within each newly created table, I would like to see every cell from the two randomly generated tables on the Grids tab that contains that specific two letter abbreviation. For example, CH. Here's the tricky part. I want each cell that contains the two letter abbreviation to be represented by a combination of the headers (column headers found in row 1 + row 8 AND the row headers found in column A). Sample results: 011, 021, 121, 311, 554.

Find all cells that contain CH and list the column header and row header in a cell together for each occurrence of CH in the two tables on the Grids tab. I am attaching a sample file with additional descriptors that I hope will explain more.

two randomly generated tables on the Grids tab have a column header and row header (see Grids)
randomly generated data consists of two letter abbreviations (see Variables & Grids)
I need to pull from random table data every cell that contains a specific two letter abbreviation. For example, every cell that contains CH
and show the column header and row header (combined in one cell) for each cell that contains the two letter abbreviation

My question is: Is there a way to systematically find every cell that contains specific text and display the column header/row header for each occurrence found within a range of cells? Please see my attached sample for further clarity.

The two tables on the Grids tab are randomly generated. They most likely re-randomized...making my example harder to understand.