I would like to merge 4 workbooks into a master workbook. I would like for the information to update with new information that has been added to the source workbooks when it is open. The range in each workbook will vary and continuously increase. These are tracking workbooks. There are two tabs in each workbook. The source workbooks have the same columns as the master. I have copied the vba code recommended in other post but unsure how to change to meet my needs. Also when I run the code it opens a new workbook.