Merge Multipe Sheet into One Summary Sheet

[erprasannaa]

Dear All,

I have 200 Sheets contains Informations based on headings,
I require to copy all sheets and paste in a summary sheet below and below .
Sheet name is equal to PO Numbers.
In the summary sheet A Column Require the Sheet Names for all lines.

Can any one help me .



Regards.

Prasanna

[patel45]

http://www.rondebruin.nl/summary.htm

[erprasannaa]

Dear Patel45

Thanks for your reply.
I tested the codes
But I can not Understand some lines.
I can not fix the range, If I changed the range it throws Run time Error 1004.

Please guide me to select range in every sheet from A1:z100

[AB33]

Try this one as an option

Please Login or Register  to view this content.

[erprasannaa]

Dear AB,

thanks for your reply.
But when i Run the code only Master sheet was created and nothing Copied in it.

Regards.
Prasanna.

[AB33]

Please see attached

[erprasannaa]

Thanks a ton

Its worked fine.


Regards.
Prasanna.