Selecting the same cells in multiple worksheets?

[Pezgordo]

How can I select the same cell range in multiple worksheets and than copy them all into a separate worksheet and/or workbook so that they show up on one page (ideally one on top of the other)? For example, I have 120 worksheets in a workbook. I want to copy and paste the same cells for each worksheet into a separate workbook, but I want all the information to appear on one page (worksheet).

 

[jbeaucaire]

A macro that does that would go something like this:

Option Explicit

Sub SummaryList()
Dim ws As Worksheet
Dim NR As Long

Sheets.Add After:=Sheets(Sheets.Count)
NR = 1

For Each ws In Worksheets
    If ws.Name <> ActiveSheet.Name Then
        Range("A" & NR) = ws.Range("B10")
        Range("B" & NR) = ws.Range("C12")
        Range("C" & NR) = ws.Range("E44")
        NR = NR + 1
    End If
Next ws

ActiveSheet.Move

End Sub

The colored section shows how to put values from various cell into a single row, then repeat for the next row/worksheet.