Linking in entire worksheet to another workbook

[space_monkey]

Basically I have a workbook with three sheets, for one group of people who will be editing the sheets constantly throughout the day; i want them to have full access. But another only needs to see the last sheet (sheet3). I've played around with protecting and unprotecting but this would be a hassle for the folks who have to work with the sheet all day. So i'm thinking that the best way would be to have a new workbook that will link back to the original workbook and either link to just the worksheet i want or link to all three, but we'll protect the new one so it will only display the one we want it to. But i can't figure out how to link to an entire sheet or workbook. Can this be done, or is there a better option?

Thanks
Andy

[space_monkey]

I found a workaround for the time being. If you select the region you want to link (source), then copy it. In your new workbook you right click and select paste special, then select paste link in the bottom left hand corner. It will link that region to the new excel file. This works fine except it's not dynamic. The link won't work if they type something beyond that region. So let me know if you can think of anything.

Thanks
Andy