Multiple workbooks in excel

[LizzyAnn]

Is it possible to have multiple tabs in one workbook pull from corresponding sheets in other workbooks.

(For example) Say Jack, Jill, and Sam all have different excel lists/workbooks, and Stan needs to see them all at once. Can Stan have one workbook that populates itself from Jack, Jill, and Sam's files?
(Assuming, all files are one a shared drive, Stan has admin rights, etc. etc.)

(I'm going assume there's some VB coding and whatnot involved, am perfectly okay with that.)

 

[SkipVought]

Hi,

" all have different excel lists/workbooks..."

Lists: I'd use MS Query to get the Lists.

You could

1) return the lists side by side

2) join the lists into one (adding the source) as an additional column.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[LizzyAnn]

How exactly would I go about doing that?
If you don't mind explaining a bit further.

 

[SkipVought]

faq68-5829

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[LizzyAnn]

.. Why, that FAQ looks oddly convenient. I'll have to give it a shot.