Good morning!

I'm still remodelling the financial model from hell but im getting there (I think). What I'm looking to do now, is copy "CPU Div Summary" sheet from "Div..xls" to all the workbooks in a directory, and save them (not updating links).

Then I want to paste links from column B from the new "CPU Div Summary" in each workbook to "DivSummary" Sheet (in the same workbook as im copying the other sheet from-Div.xls), so that the first workbook pastes links for its column B into "DivSummary" Col B, then the next workbook pastes its col B into col C then the next workbook's Col B to Col D etc until all the column B's from each work book are 'pasted link' sequentially until all the workbooks are looped through (i.e. Cols B-BZ in the "DivSummary" sheet = col B from all workbooks in the directory)

Then it to do the same for each Col C, D, E, F, G, H.

This hopefully will enable me to summarize 100+ sheets into a master document for pivot tabling etc, rather then the 1000's of external lookups that plain dont work at the moment.

Can anyone help and save me a weeks work?!?!