Sheet sharing

[aek_nikos]

Good morning,
I've made a workbook with 50 sheets of data and 1 sheet of results (of those datas). I want to share these 50 sheets with 50 editors (each one of them gets the sheet that represents his department).
Is there a possible magic solution for me, to share each sheet (and only this) to the corresponding editor and at the same time get the results i want to the sheet i do not share?

I KNOW, I KNOW I ASK A LOT but i live in hope!!
Thanks a lot

 

[xlhelp15]

I believe it is possible through VBA!

For that, you would need to write a code on Workbooks_open event by checking their username with the help of Application.username and let the macro to enable only the respective editor tab and rest will be hidden.

 

[aek_nikos]

I believe it is possible through VBA!

For that, you would need to write a code on Workbooks_open event by checking their username with the help of Application.username and let the macro to enable only the respective editor tab and rest will be hidden.

Appreciate your answer.
I am not that into VBA yet so i can't really write that code, so i'll keep looking
Thanks a lot