You need a unique rep table in the middle of these tables.
You have Kamal twice so that won't work in this current set up.
So make a table of unique employees by ID.
Do this in another sheet and then create a linked table of all 3 sheets to make them power pivot.
Then create a relationship between the Emp Table to your Unique Emp Table and the master account table by ID to your new emp table.
You should make sure the ID will stay unique and isn't a position id, that could be replaced by another employee.
By this you should be able to pick the data from each table you need. Use the Employee ID from your new table to create the basis of your pivot.