riverman wrote:
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

Lots of Xcel forms out there.
http://www.excelforum.com/ is one. If you search google groups for
Excel you get about a dozen. I am not trying to be smart. I have used
them to get answers and it usually happens pretty fast. You don't get
near the number of smart asses do on Roff.

This guy has some pretty good stuff on his webstie.
http://www.cpearson.com/
If you goggle "Excel Consultants or help" you get many hits. I use to
have a list of about 4 that were worth reading every week, it made for
a good Excel education.
I think for your problem you can make the sheet number be a look up in
a another column.(say row 2). I think I have done that before but I
can't get it to work right now.