Pulling Data Based on Name to New Reformatted Sheet

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

The Output is essentially the data by role sheet but rearranged so that the salespeople are arranged by store. If that makes sense. I need to the data by store sheet to populate from the data by role sheet based on the name of each sales person.