Is it possible to create a link between 2 Workbooks (such as Workbooks A & B in the screenshots below) which automatically updates? When the active cell in Workbook A is changed, I'd like Workbook B to display all instances of the value contained in that active cell, as well as all data associated with it.

1A.PNG

2B.PNG

3E.PNG