workbook A

[Shail_Ach]

I have workbook A with me which is master sheet with data & workbook B shared with client with some part of data from workbook A.
So whenever the updates are made in workbookB with green highlights for eg; I want it to reflect in workbookA as well automatically.
Whats the simple solution?

Another catch: I have multiple worksheets in workbook A & single worksheet in workbook B. So I want the related data from Workbook B (with VLOOKUP perhaps ) to come & sit in respective worksheets of Workbook A.

Also, since the workbook A has extra data, I want complete data from workbook B to reflect on WorkbookA, & remaining data in Workbook A to be same as is, without showing NA/error

 

[Shail_Ach]

I have workbook A with me which is master sheet with data & workbook B shared with client with some part of data from workbook A.
So whenever the updates are made in workbookB with green highlights for eg; I want it to reflect in workbookA as well automatically.
Whats the simple solution?

Another catch: I have multiple worksheets in workbook A & single worksheet in workbook B. So I want the related data from Workbook B (with VLOOKUP perhaps ) to come & sit in respective worksheets of Workbook A.

Also, since the workbook A has extra data, I want complete data from workbook B to reflect on WorkbookA, & remaining data in Workbook A to be same as is, without showing NA/error

Col.C is unique for both to get data from Client to master with a VLOOKUP etc; and want data from Col,G,I,K from Client to master in same columns across Rebranding tracker Q4, also Q3 along with colors. But without changing rest of the values