Running mutiple excel sheets on mutiple computers

[Lost]

Ok I am running 4 computers with 4 different workbooks. Then I have a 5th
workbook that is supposed to pull data from all 4 sheets. This works when I
have all the sheets open on one computer but when I use multiple computers it
doesnt work. All the workbooks are in the same folders on a networked shared
drive. Im kinda new to this so if there are ideas out there they would be
helpful

Thanks

 

[Lost]

Ok I think I have it figured out but im using alot of If and, sum if and, and
Vlookups. The majority of the formulas have over 300 characters so I use '07
to program and they use '03 while running the sheets on the production floor.
I dont get any errors within the cells but I also dont get the information
its supposed to be pulling either. I have autoupdate selected for all sheets
but im lost lol. Im new to excel learning as i go. But what I need the
sheets to do is up date real time like they do when I use one computer while
running multiple computers. Is this even possible?