I have about a hundred workbooks, all having the exact same format (ie. tables), but have different data in each individual workbook. Sometimes I need to add or remove a row from a table within the workbook, but having to do it on all the workbooks individually is a painful task.

I'm new to VBA so I'm not very sure if this is possible, but I am wondering if there is a way to have lets say a Master Workbook which controls all the remaining workbooks.

My initial theory is that by running a script whenever a Slave workbook is opened and automatically compares itself to the Master workbook (closed if possible) and make any changes if necessary. However the problem is I want to keep the data of the Slave workbook and I think this script might replace empty cells from the Master workbook into the Slave workbook.

Is there a way around this problem, or are there any other way which does the same job more efficiently?

Thanks in advance.

-Henri