To expand on your comment re: grabbing info from other
workbooks, we routinely grab info from other
workbooks, BUT we now only use raw data versus
calculated data, especially when it comes to tracking
dates & time. One workbook tracks ~50 program
management workbooks & not all are updated at the same
time so we capture their inputs then calculate in the
tracking workbook.