Using Data Validation to select one of five lists of names.

Not sure if this what is required:

Tab "Report"

in D7

=IFERROR(INDEX(Data!$B$1:$F$17,MATCH($C7,Data!$A$1:$A$17,0),MATCH(Report!$C$3,Data!$B$2:$F$2,0)),"")

copy down to D11

similar formulae in D14/D18, C18

Data changes on selection of Week

Maybe another way to do this would be to put multiple If/Then formulas in each cell of the "smart" roster?
e.g., for cell A2 on the Roster tab (see attached), a formula that checks for the Week showing in cell C3 of the Report tab.
If C3 shows "Week 2", then A2 would display "John Test2"; if C3 shows "Week 3", then A2 would display "John Test3", etc.?
Here's an image of the Roster tab draft I'm attaching:
Smart Roster.JPG
Thanks again for any help,
jaljr