hello

i have some workbooks (A) that are connect to multiple workbooks (B) to import data

now i want to create a master workbook that goes get data from workbooks A, but if i change in workbooks B some data, and without open the workbooks A, how the master workbook will update the data?

Workbooks B -> Workbooks A -> Master Workbooks

if i change in B how i can update the master without manualy open the B to update??