Attributing same cells but different sheets, to new summary sheet

So I am in the process of creating a table of my results from many different worksheets.

Each cell in my column needs to reference the same cell in each worksheet, but change the worksheet:

So first cell =Sheet2!$B$2

The next cell, same column, =Sheet3!$B$2

The next cell, same column, =Sheet4!$B$2

So basically I need the sheet being referenced to change, but not manually as there are hundreds of sheets. Is there a formula that would work to do this automatically? Or a quick way to do this? Otherwise it will be a lot of slow manual data input that would be prone to error.

Thanks!

SO I ended up with this:

the sheet I need to reference first is Area 20

=indirect("Area (20)"&(ROW()+1)&"!"&$b$2)

should I write this differently? I just keep getting zero as an answer

Each sheet afterwards is named not in sequence, for instance, Area (20) is perceded by Area (29), but is the next sheet in the row.