Pulling Data Based on Name to New Reformatted Sheet

[ngor3431]

Hi,

I have a problem in need of a solution. Please refer to the the attached sample sheet. Basically I have one sheet that lists sales team by role in a particular format. The other sheet is arranged by store with each store having a varying amount of salespeople with differing roles.

I would like the data from the role sheet to be transferred to the data sheet. I have previously posted this problem and got quite a neat solution but since then have addes a few columns and the formulae havent worked. Any ideas would be greatly appreciated.

Cheers,
ngor