Master Workbook to reflect the data entry to all connected Workbooks(child Workbook)

[Prakash Malviya]

Dear Community,

Is it possible to create a master workbook in the confluence, where if i add an addition cell or table it should also be added to all the workbook that are connected to it automatically, Without effecting the old data in the workbooks.

if yes how can we achieve this, can you guide for the same.

Thank you

[Prakash Malviya]

Can we download the Master and Child Workbook and create a Macro such that we add any new cell data it will also effect in all the child workbook and worksheets and then it can be reuploaded back to the confluence