Linking Workbook Pages

[doug.washburn]

Hi,

I have a number of people working on different versions of Excel. Each have a workbook that they update monthly and their workbook can contain 1 to 6 sheets. I would like to create a "master" workbook, that when I open it, goes and grabs all the tabs from each of the "working" workbooks and organizes them all into the master workbook.

Is this possible?

 

[Smitty]

I'd start by recording a macro pulling the data. That approach would work even if user's leave their wb's open, as you'd just need to access the data, so read-only shouldn't be an issue. If that'll work for you, then post the code you get and someone can clean it up for you.

You could also create a master wb that links to the others. Check out Microsoft's new SkyDrive service (free) which allows you to do real-time file syncing.

HTH,