Data Importing

Hi there, I am new to excel and am trying to set up a "Master/Slave" setup between 1 master excel workbook that will only be used for viewing and 2 slave workbooks that will be updated periodically.

I have done extensive searching and have yet to find a solution that fits my specific scenario. I am looking to essentially have an exact replica of these two different slave workbooks in the Master workbook. Meaning if I update sheetA in slave workbook 1 then sheetA in the Master workbook will be updated to look exactly the same.

I have looked into linking the specific cells but as I may need to add extra rows to say sheetA in the slave workbook, I will also need the Master workbook to reflect this. Thus cell linking was not the solution to my answer.

Next I took a look into data connections. My problem here is that when I import a data connection from one excel workbook to another that it must be imported as a table. This is fine but, I need the formatting of the excel sheet to remain the same and as it seems I am unable to do this.

My question is essentially, is there a way to import data from one excel workbook to another while keeping the formatting i desire and keeping it constantly updated,even if say new rows or columns of data are added?

One way to do this is to have a piece of code which fires when the master workbook is opened which entirely deletes the existing copies of the slave sheets and replaces them with a new snapshot. However, any alterations made to the master sheet would be lost. Does this sound like the sort of thing that you want?