absolute ref formula troubles

[Dave W]

I am using the following formula in a worksheet that
summarizes various info.

=IF($A18<>"",SUMIF('Base Bid Item (9)'!
$B$11:$B$110,">=M.*",'Base Bid Item (9)'!$G$11:$G$110)-
SUMIF('Base Bid Item (9)'!$B$11:$B$110,"M.10*",'Base Bid
Item (9)'!$G$11:$G$110),"")

The formula works just fine, but I want to improve it
so that I can copy it down the column and have the
worksheet reference change to the next worksheet instead
of manually changing the worksheet number. I saw a post
the other day that used indirect in the formula to
accomplish this. =INDIRECT("Week "&ROW(23:23)
&"!"&"$E$10")

so I tried it in my formula...for the first two auguments

=IF($A18<>"",SUMIF(INDIRECT("Base Bid Item"&ROW(9:9)
&"!"&"$B$11:$B$110"),">=M.*",INDIRECT("Base Bid Item"&ROW
(9:9)&"!"&"$G$11:$G$110")-SUMIF('Base Bid Item (9)'!
$B$11:$B$110,"M.10*",'Base Bid Item (9)'!
$G$11:$G$110),"")

Big surprize, it doesn't work

Can anyone help!

Thanks in advance

 

[Dave W]

I forgot to add
I am getting an ref error