Find column title in a range and return the title of THAT column

Sorry, the title is a disgrace but hopefully the attached data set will make it clearer.
I have constructed a shift roster (sheet1) where the column titles are the shift types and the row titles are the date of that shift. The content of the table are the names of the people who are working each shift. I want to use this data set to generate a roster in a different format (sheet2). In sheet2, the row titles are still the date of the shift but the column titles are the names of each person. I want each person to be able to just look at their own column and see all there shifts in date order from top to bottom.

Is there any way to lookup or match the table contents in sheet1 to generate the contents of sheet2? i.e. if I am Laura, cell G7 in sheet2 would search the range D7:L118 in sheet1 for cells containing "Laura" (i.e. G6 in sheet2) for the row in sheet1 matching that particular date (C7) and return the name of the shift I am working on that date (the title of the column where it was found), if any. For G7 in sheet2 it would be "USS" but in G10 in sheet 2 it would be "twilight."

The practical use of this would be that if I am Laura I can just look down column G on sheet 2 to see all my shifts in order of date.

I have looked into xlookups, nested if functions and index/match I feel like I need a combination of more than one of those functions and I don't understand them enough!

In D7

=IFERROR(INDEX(Sheet1!$D$5:$L$5,MATCH(Sheet2!D$6,Sheet1!$D7:$L7,0)),"")

Copy across and down

Thank you so much!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

I have a follow up question (if that's allowed!). Is there a way to adjust the formula so that it returns an error if I've accidentally put someone down for 2 shifts on the same day? I tried changing to IFNA but that doesn't seem to work!

In D7

=IF(COUNTIF(Sheet1!$D7:$L7,Sheet2!D$6)>1, "** ERROR **!",IFERROR(INDEX(Sheet1!$D$5:$L$5,MATCH(Sheet2!D$6,Sheet1!$D7:$L7,0)),""))

Copy across and down: change warning as required!