Execl - Copy forumlas to multiple worksheets

Hello,

I am having trouble copying formulas to multiple worksheets.

On the sheet name tab, I click "select all sheets" then I type in my formula

=SUMPRODUCT(($M$8:$M$20)*($K$8:$K$20="Discretionary Fund")*($J$8:$J$20=DATE(2009,7,5)))

The formula copies into all the other worksheets just fine, and works great in the first worksheet, but on all the subsequent worksheets I get #VALUE.

Help!

Thanks!
MEB