Combining Data from Multiple Sheets

Hello,

I badly needed some help with the file im creating and i know that all people here have a big heart to help.

I am trying to consolidate the data from different excel sheets so i can create a dashboard. My challenge is, whenever i try to create a relationship, it keeps on saying that there are duplicate values and cannot create the relationship between tables. I tried using power query but it's just adding another column for the tables.

What i really wanted to do is to combine all sheets into one sheet so i can create a pivot table containing all the data from different sheets. I need all data to be associated with the same employee on the same date.

I have attached a sample file here.


Thanks in advance.... Hoping you could help me please...... please... please...


Thanks!
Ae