This is not possible. You either give users access to the document or not.
What you want to do instead, is link several sheets to a master sheet.
You can link data from a cell in one sheet to a cell in another sheet.
Simply open 2 sheets, select the cell you want the data to be in, press
= and then click on the cell you want it to be linked to in the other sheet and press enter.
It will automatically create a formula for you that shows whatever is in the other sheet.
Your users will work in their individual sheet, and you use the master sheet to work with the data they are entering (like adding totals, averages, etc).
There seems to be a little bit of confusion in the comments on how this would work from a security point of view.
Therefor this edit.
Lets say, you have a network share with the following 2 folders:
###### is an excel folder for each person, and rights are setup so managemant and that user can access that folder.
Management only has access to the Management folder.
In the Management folder, links are created to each users sheet, to different cells.
The user edits their sheet or can view it, or however you want to do it.
When you open the management sheet, it asks you if you want to refresh the data. All cells are updated and recalculated.
A user can only access the sheet in their folder, thus they cannot see the rest. Given they have no access to the management folder, they cannot access that data either.