Concatenated sorting

I have a daily report that I need to find and concatenate 3 cells to show the reason of the Criteria X, Y, and Z in the report table. I made a workbook with an example of my problem. I need to find in Sheet 1 column A1 today’s date (this table will have several days data), then from that point of the range move to the columns “X”, “Y”, “Z” and find what are the reasons for “X”, “Y”, and “Z” in this example I put Name, Initial, and Last name. I need to copy this data to Sheet 2 and insert the 3 cells values concatenate them in one cell, all the values (names) that match criteria X, Y and Z in to separate tables in the same sheet.. In the example will start in cell Sheet 2 cell B4 and insert all the full name of all the Name, Initial and Last name that were entered in the columns mark “X”, and do the same for “Y” and “Z”.

The key here is that the function use to find today date will replicate the data sorting every day and out put the same report daily.

I know that will be easy if the full name be entered in one cell at the data entry time, but I need them separate at that point.



Any input how to do this will be greatly appreciated.