2 Column Search Options then Show Results (Google Sheets)

Need your expert advise on how to do this in EXCEL version 2019

If User will choose to search for data for Team A in Column A, Row 1 (A1), all the information for selected Team A member will show in A5:D5 with column headers. If User will choose to search for data for Team B in Column B, Row 2 (B1), all the information for selected Team B member will show in A5:D5 as well with column headers. For instance, if User searches info for John in A1, all data for John will show in A6 while if User searches info for Donna in B1, all data for Donna will show in A6 too.