Hi...

I am about to send out a template (Say file A) to many users, who will
fill details in the template and then send back to me.

I have a summary tab (Say Tab bb) in the template going out that
summarises all data contained within the template.

Once I recieve all the File A's back (approx 100) I need to consolidate
the tabs (ie Tab bb) , ie compare the submissions side by side in one
workbook
Is there any easier way than copying and pasting the sheet 100 times)
Any consolidation type process that can automatically be run by a Macro?
Anything I need to add to my File A (or Tab bb) sheet before sending
out...?

Thanks and Regards

D


*** Sent via Developersdex http://www.developersdex.com ***