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...