Is there a way to track changes in workbook A if workbook A references
information in workbook B.

For example, if workbook B, cell A1 has the name Jim and it is changed to
James, will workbook A, cell A1 (ref workbook B, cell A1) indicate that cell
A1 changed?

I appreciate any assistance.