gather data from one sheet to another

[Ramon Haagen]

Hello,

I attached a file to make it easier to explain and hopefully to find a solution.

In the file there is a tab individual performance and working hours. I would like to gather from the tab working hour in the tab individual performance the amount of hours worked in that week per person. how can I do this?

[#2]

I find that your file is protected, so I cannot open your file. 

I think the function "INDIRECT" is helpful to you. Let's have a look at the sample file I prepared. 

[#3]

I find that your file is protected, so I cannot open your file. 

I think the function "INDIRECT" is helpful to you. Let's have a look at the sample file I prepared. 

[#4]

@Man Fai Chan 

Hi, I cant seems to fix it with this. Password is 1234

Could you have another look in the file/