Excel logic

Dear all,

I hope you can help me. I have to admit I am not a pro in Excel, so maybe there is an easy solution - if there isn't, it will take me hours ...

So, what I am doing right now is a workload profile. It has a breakdown to different tasks and sub-tasks (think of: fruits: cutting apples, slicing bananas ...)
Every team member has to fill in that sheet.

But below I have to sum it all up - how many hours does one specific task take for all team members. It's always the same logic, but for some reason, excel can follow the logic of:

Cell a1 is = b11
a2 is = b22
a3 is = b33 ...

and so on, but excel messes up here. Is there a way I can teach it how to do it properly?

Thank you in advance!!!

Try this in A1:

=INDIRECT("B"&ROW(A1)*11)

Thank you for your help, guys! You saved me a lot of time ...


Sorry, another one, kinda similar to the on before though:

I have a team summary by task (overview). This sheet has to be linked to the single team sheets. There is already a sum up for the team available, but I can't simply pull it down because

in the sheet it is directly one below the other, in the summary it is H3= Team!K434, H12 has to be =Team!K435 now and so on ... the distance again is always the same.

Thank you!