Automatic changing of sheet name for cell references

[urbaneruralite]

I have a workbook containing many sheets. All are numerically named, 1 through 200. I would like to copy the same cells from each. Can this be done without manually typing each sheet name in the cell references?
As in:
=1!$b$2
=2!$b$2
=3!$b$2
=etc.

 

[fairwinds]

Welcome to the board!

=INDIRECT("'"&ROW(A1)&"'!B2")

Will give you the data from sheet 1, then just drag it down to get the following sheets.