If you want them updated when the workbook is opened wouldn't just Linking to them be a better option?
To have your code import the workbooks each time the workbook is opened place it in the Workbook's
WorkbookOpen Event.