When you copy and paste use the Paste special on the edit menu. there is a
box on the bottom left corner labeled link. This will put a link link the
data rather than use the actual values.

"Bart Hautala PE DE" wrote:

Ive got 2 xls file each with 7 tabs in them lets call them books A.xls and
B.xls. I want to take all the information from the 7 tabs in book A.xls and
place it in a new book called ZZZ.xls. So I have all the information from
book A placed in 1 sheet on ZZZ.xls. I know I can simply copy and paste this
information on tab at a time but the trick is I want anything that I update
in book A.xls to be reflected in my new file ZZZ.xls. So if I add a line in
the 3rd tab in book A I want it to show up in the appropriate place on my new
ZZZ.xls file. So how do I do this?