Couple of thoughts ylp, Since your just using one sheet one each workbook why not just use 3 sheets in one workbook...if possible?

If you must use 3 different workbooks then have book 3 updated when you close book 2...