Updatable Master workbook

[Curt16]

Hello Everyone

I am new to the form and also a pretty standard excel user and hoping this is the right place for this question.

I trying to create a master workbook based off other workbooks with a single sheet in them, but I would like it to be updatable.

for example:

Master workbook that is empty but I would like to have MH1 workbook , MH2 workbook and MH3 workbook to be listed in the master as sheets, but I would like to be able to go into the original MH1 workbook to make changes and than have it automatically update in the master for MH1 sheet.

I have attached some files to show examples of the data I'm using.

if this his something that is possible, I would greatly appreciate any help.

Thanks

[davesexcel]

It is possible.

Linking the cells in the master wb to the source sheet linked cells.

Test it out.
With your master sheet open and MH1 open.

The code would be in Master sheet.

For this example have MH1 selected, run the code.
ST1 sheet will be copied over to master wb, then it will make a formula linking it to the source workbook.

Click on the source workbook controls and it will change the controls in the master workbook

Please Login or Register  to view this content.

[Curt16]

THANK YOU!! This works great.

[Curt16]

Thank you for the help given on this issue it worked prefect but I was wondering if it could be taken a step further.

the scrip provided lets me move/update the original sheet and it be shown in a master copy that will update live based of the original sheet. What I was wondering is there a way to still have all this still working but if I update with in the master copy it will also affect the original sheet, instead of the update only working one way.

Thanks