Summary sheet auto update
 

i HAVE A SUMMARY WORKBOOK WHICH AUTO UPDATES FROM 3 OTHER WORKBOOKS. THESE 3
WORKBOOKS ARE LIVE DOCUMENTS AND WILL BE RE-SAVED CHANGING THE REVISION
NUMBER ONLY. THE LOCATION WILL REMAIN THE SAME.

MY SUMMARY CURRENTLY REFERS TO EACH WORKBOOK AND BRINGS BACK THE DATA I
REQUIRE. HOWEVER, HOW CAN I GET THE SUMMARY TO FETCH THE SAME REVISED DATA
FROM THE 3 WORKBOOKS WHEN THEY HAVE BEEN RESAVED WITH A DIFFERENT REVISON
NUMBER?

IN SHORT - SUMMARY READS FROM WORK BOOKS 1,2,3 v11. ONCE THEY HAVE BEEN
RESAVED I NEED IT TO AUTOMATICALLY UPDATE FROM WORKS BOOKS 1,2,3 v12 WITH
MINIMAL EFFORT.

IS THERE SOME KIND OF LINK THAT I CAN PUT IN THE SUMMARY SO ALL I HAVE TO DO
IS CHANGE THE NAME OF THE FILE TO LOOK FOR?

THANKS FOR YOUR TIME ON THIS

JAYNE