I have a workbook created for each of several Bureaus. I then have a
Deputate Workbook that the corresponding Bureaus roll up into. I would like
to create a Department Workbook that will pull from the Deputate Workbooks,
however when i tried a rough sample, the Department Update will only work if
you open the Deputate Workbooks and update them first. Is there a way, to
set the Department Workbook to populate with the most recent data by only
linking it to each of the Deputates, rather than the 25 individual Bureau's
for each cell?

I appreciate any assistance that can be provided.
--
Scott