Is there anyway to have destination cells update in an open workbook from
source cells in closed workbooks?

I have a Summary workbook that contains links to many closed workbooks in
the same directory.

The closed workbooks also have some links to the open Summary workbook, so
that when I make a change to a source cell in the Summary workbook a
calculation would be done in the destination cell of the closed workbook and
another destination cell in the Summary workbook that contains a link to the
calculation result in the closed workbook will update.

Thanks,
Fred