Count Text Across Multiple Sheets

Ok so I have a workbook with 29 sheets.

28 of those sheets contain a column with text data in them.

The text data in each column sometimes contains duplicate fields from sheet to sheet.

What I want to do is fill the 29th sheet with one column containing all of the other sheets names, and one row containing all of the different text fields from the data column without any duplicates. That part has already been completed manually, however, if a new text field had to be added to a certain sheet, I would need that new field to be automatically added to the new Master sheet into the row containing all the different text fields from the data columns.

Then for each name in my new 29th sheet, I want to put an "x" in the row/column cell if that text data appears in the individual sheets data column.

E.g I have 2 sheets. The first one is called Apples, the text data column might say: green, smooth, sour etc, with each word in an individual cell.
The second sheet is called Oranges, the text data column might say: Orange, smooth, round, sour etc.

I want to fill my new master sheet with a column listing the two sheet names (Apples, Oranges), a row with all the possible text data names without duplicates (Green, Orange, smooth, sour, round in our example), and then I want to input an "x" wherever the sheet name contains specific text data from the newly created row.

In this case I would expect to see: apples.png