Excel 2007 : Referening from one workbook to another formula.

I apologize in advance for the typo's.

Here's an example of what i have and what i am trying to do. For reference, i have attached the file with 2 sheets referencing each other in the same workbook and a file with each source and display files.

I don't expect anyone to do any the work, i just need to know how to edit the following formula to make it see the exact cell but just in another workbook.

I have the following formula in place to reference from one sheet to another in the same workbook:

=IF('Inside Turnover'!$E$45<>"",'Inside Turnover'!$D$45&" "&'Inside Turnover'!$E$45,IF('Inside Turnover'!$D$45="","",'Inside Turnover'!$D$45))

BUT i want to do this using IST1 as the source where someone can do input and update while IST2 is displaying the changes on a monitor in another room.

The problem i am having is this.

The above formula is doing the following:
An entry is made in D45 on the Inside turnover sheet. Another entry is made if needed into E45 that turns the cell fill to yellow in D45. If an entry is made in E45, it turns the text in D45 Blue. E45 and D45 are never used at the same time. I also have conditioning formulas making the color changes.
Attachment 145242Attachment 145243Attachment 145244

If you look at the inside turnover NEW. that's what i want to do but in 2 different files as described above but i am having trouble gettingthe different files to act the same as the original file does.


When opening the files. i only want the columns D. E. F. to have the formulas to have an entry on Inside Turnover tab of the Inside Turnover(NEW) file which i have also saved as Inside Turnover1. I'm sure it will be obvious. Yeah right. haha
TMI? or not enough?