Hi Dave,
I tried your suggestion.. it does not give the desired result.. it
copies everything from all the sheets to Row No.2 in the Summary Sheet
and keeps on over writing on the same row until the last sheet in the
workbook... so what remains on Summary Sheet is the detail from the
last sheet.

Is this clear to you.
Thanks for your time
Ashish Kumar