Report sharing access



There are 7 individual sheets with information on various industries in each of the sheets. I have created a report to pull information on a particular industry and have shared that with a collaborator. However, as he does not have access to the individual sheets, he's isn't able to see the information on the report. 

I do not want to share the individual sheets as it contains info about other industries as well.

Is there a way for this? Thanks,