drag and fill annoyance

[coadhall]

hello. Don't know if this has been asked before but it is doing my head in.
Using Excel 2010, I am creating a workbook to set up a register of risks.
Each risk has its own tab along the bottom (Risk1, Risk2, etc you get the idea) and I am trying to create a summary spreadsheet where some of the details are displayed, for ease of control etc. Like Title, probability, when raised, who owns it etc....
The pain is, I have created the first row, picking detail from Risk1 tab. What I want to do is then drag and fill the rest of the rows to select the other tabs information. but what is winding me up is that I just get the following.
cell B4 =Risk1!B2
cell B5 =Risk1!B3
cell B6 =Risk1!B4 when what I want it to read is Risk2!B2, Risk3!B2 and so on and so forth.

Is this possible or am I just being thick about it.

thanks in advance

[Special-K]

Try this (untested)

=INDIRECT("Risk"&ROW()-2&"!B2")

[BenMiller]

Try

=INDIRECT("'Risk"&ROW(A1)&"!'B2") in B4 and drag down.

[coadhall]

Thank you both for your prompt replies, my laptop is now safe from being thrown across the floor.

many thanks