External Data Help

[Erays]

Each month I create a new workbook for 13 employees each book is the same except the name (Dale workbook 5-2005.xls, James Dale workbook 5-2005.xls and so on) and in each one of these books is a page named results, I have to make a monthly master that includes the 13 pages that I have to copy from each book and past in there proper place. I woul like to create a master that the pages are linked to the employee workbooks and there respective results page

[NashProjects]

It might be a bit formula intensive to create a linked entire page to each of the 13 pages....

maybe search down the macro route and create a file that you open and click a button which will cycle through all 13 files and copy the results page..

It will be just as quick to update and will not leave any forumla residue..