Is there any way to have a "live" link between two workbooks? I have two
workbooks, one called CK2 and the other is call Lab. I would like the data
that is entered into the Lab workbook to automatically be displayed in the
other workbook.

The workbooks will both be opened, and running simultaneously, by different
users. And because the workbooks are used everyday, I have it set up so that
the users can't save the master workbook - when they save the file, it is
really just saving a copy to a location on my network.

Is it possible to do this? Any suggestions or help would be appreciated.
Thank You!