Copying rows from multiple sheets

[gcs075]

I have a document with 48 sheets of data, and want to copy the same row from each sheet into a new document. Is there a way to do this simultaneously to avoid copying and pasting from each sheet?

 

[Joe4]

Welcome to the Board!

If there is any pattern to the way the sheets are named, you may be able to use INDIRECT formulas in Excel.
Otherwise, you may need to use VBA.

So I think we need more detail, such as:
- What are the names of the sheet your wish to copy?
- What range are you copying from?
- What sheet you are copying to?
- What range are you copying to?
- Are there any sheets other than these 49 in your workbook?

 

[gcs075]

Thanks for responding Joe4. I was asking on behalf of my daughter, who is at uni, and she's found a way now. Appreciate the offer of help though.