I need some advice on how to pull data from a closed worksheet to a
master doc. I am using a cell function like below.

=CELL("contents",'P:\Blanco Kitchen - 200447\[200447-Process
Map.xls]Actions'!$C$4:$D$4)

It works fine if the Blanco Kitchen doc is open, but I have over twenty
projects to tract simultaneously and it is a hassle to open all of them
to update the master doc.

Any help would be appreciated.
Regards,

Mark Benzell
Inside & Out Remodelers