I am having a bit of a problem. I have multiple worksheets that are all
setup the same. The first sheet is called "Start" and the last is called
"End". These are "templates". The data is on the sheets in between. I
have a formula that works just fine as is.
=Sum(Start:End!B1)
This sums all the "B1" cells in all the sheets from Start to End.

Here is the problem. I would like to change the row 1 to a variable that i
type into a an "input" cell. Then have that cell used in the current
formula so I can change what cell is being summed w/o having to physically
change the formula. I can't seem to get it to work. I've tried =Sum
(Indirect("Start:End!B" & A1) but to no availe.

Can anyone help out on this.

---
thanks in advance
gr