I have a workbook that contains 1 "master sheet" of Personnel data and 30
other sheets for individual line managers. The individual line manager
sheets contains a subset of this master data relevant to their teams only.
Is there anyway to only allow certain individuals to select their sheet? I
imagine a sort of Range Protection with permissions but at a worksheet level.

Failing this I guess I'll have to resort to hiding rows and columns and then
use worksheet protection to allow un-hiding with a password

Thank you all in advance
Andy