Thank you for responding,

I would like to have secure way for each department manager to access one of
many workbook sheet while being easy to integrate the entries from 10
different people.

Spiky gave me a good answer below.

"Pete_UK" wrote:

So, what exactly are you asking for?

Pete

On Nov 4, 11:48 pm, Mikekne wrote:
I have a budget workbook with different tabs for each department. These tabs
are also linked into support tabs. I would like to be able to save a master
workbook for each department but only allow them to see their own department
tab (10 different workbooks, each showing a different tab). Then use the
merge function to bring all the changes into the master.