Hi CJM -

Is the format the same in both the individual workbooks and the
corresponding worksheet in your summary workbook? That is, if data
range in individual workbook is d5:Z50 is data range in summary
workbook ALSO d5:Z50?

Further, do these mgrs email back their completed files OR are they
saved to some common folder?

I may have an easy solution for you .... no manual cut/pasting req'd!

//ray