Linking workbooks

I have 4 workbooks with approximately 12 sheets with the information rolling
up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets
on a master recap. All the information will be coming to me by email from
all different users. Is it possible to have all this information
automatically link into the master recap or would I have to manually type it
in.

Any help would be appreciated.

Thanks

"Fawn" wrote...
I have 4 workbooks with approximately 12 sheets with the information rolling
up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets
on a master recap. All the information will be coming to me by email from
all different users. Is it possible to have all this information
automatically link into the master recap or would I have to manually type it
in.

If you just want to sum, count, average or the like across all of these
workbooks, Data Consolidate would make it relatively painless if all of these
files were in the same directory. If you want to pull values from each of these
files individually, there's unavoidable work involved.

If all the files had similar filenames, see the first alternative in the article
at this link.

http://www.google.com/groups?selm=zK...wsrange r.com

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.