Track changes across two workbooks
 

Does anyone know if changes in workbook A can show changes in workbook B if
workbook B references workbook A?

For example. Workbook A, cell A1 has Jim. Therefore, workbook B, cell A1
has Jim.

If workbook A, cell A1 is changed to James, is there a way to flag the
change in workbook B?

Reason for the question is our office gets a feeder file that we use and we
are trying to flag any changes on our workbook.

I appreciate any help.