Copy from all sheets and paste it in one sheet

Hi All,

I need some help on the below:

1. There is information in Col-B, Col-C, Col-D and Col-E in sheets named Sheet-1 and Sheet-2.....etc
2. There is an sheet called "Output" and need information from all Sheets on this sheet
3. For each of the row copied from a particular sheet, need the sheet name against that row.


I am able to copy the content from each of the sheets but I need the names of the sheet against each of row copied from that particular sheet.

Please Login or Register  to view this content.

Attached is the sample for reference and request help around resolving the above.

Kind Regards,
Srikanth

Hello sreeks,

Please try this Code:

Please Login or Register  to view this content.

Sample Workbook attached.

Regards.

Hi Winon,

Thank you so much for the quick response and solution.
The above works flawless when there are two sheets, however I have around 300 sheets in one workbook.

I am bad at loops tried implementing the logic in loop but was unsuccessful. Please correct and advise as below:

Please Login or Register  to view this content.

Kindly request you to advise.

Kind Regards,
Sreeks

Try this:

Please Login or Register  to view this content.

@ xladept,

Great Coding my friend! However, I would tweak it somewhat to the following below:

Please Login or Register  to view this content.

Thank you so much for your help, though.

Please try the attached File with the Code as amended.

Kind Regards.

@ Winon - Nice tweak - I wondered what those spaces between postings were for
Thanks for the rep

You're welcome and thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

You are welcome sreeks,

Glad we could help. Also thank you for the Rep!

Regards.