In Excel, how can I make worksheet references relative?

For example, I want to insert the following in row 3, in cells A through Z:

Sheet2!$B$5 Sheet3!$B$5 Sheet4!$B$5 Sheet5!$B$5 etc.

I know how to make the cell number absolute (with the $-signs), but I cannot
get the 'fill' to change the sheets when I drag the function command across
the different cells in row 3: it keeps the worksheet reference absolute,
referencing Sheet2. How can I make the worksheet reference relative, so it
changes the sheet number for each successive cell?

--riverman