reference multiple sheets

Hi,
I tried the last excel file you sent and it's not working. For some reason under "intro" & "Lavrik" it shows 1 and also under "guided" & "Lavrik" it always shows 1.

I cleared all the other sheets of data and only left data in sheet number 1.

Right now in the monthly report there should only be and intro for Lavrik, Darya, Anatoly and Andre.

I think that the first function you told me to use worked perfectly. It just couldn't handle more than 27 sheets. Can i just write "Sheets" like you did with the named references instead of writing "1", "2", "3"???? Or would that not work?

You also said I can split it, what did you mean?

I am kind of new to excel, thanks for all the patience!