If columns are used in same format as in 'Data by Store' tab, try this.

D3, then copy down & across

=IFERROR(VLOOKUP($B3,INDEX('Data By Role'!$A:$AI,1,MATCH($C3,'Data By Role'!$A$5:$AI$5)):INDEX('Data By Role'!$AI:$AI,65536),COLUMNS($D3:D3)+1,0),"N/A")