Links in multiple worksheet.
 

I created an Excel workbook with multiple worksheets. Some worksheets have
multiple cells/data in common. For example, my worksheets contain invoice
numbers that may be repeated in other worksheets within my workbook. In one
column I have a cell where I enter the status on collections for that
invoice. Is there a way for Excel to update all worksheets within my
workbook with the information I enter in the 'status' cell where the invoice
number is the same in the other worksheets?
--
Randy