What I would like to do is a SUMIF from sheet First to Last and
everything in between, but I know that isn't possible, so I've been
working on a workaround. This is what I have so far that gives me a
#VALUE! error:

=SUMPRODUCT(SUMIF(INDIRECT("'PD
#"&ROW(INDIRECT("1:2"))&"'!A:A"),A8,INDIRECT("' PD
#"&ROW(INDIRECT("1:2"))&"'!F:F")))

My sheets are named PD #1, PD #2, PD #3, etc. (Right now I'm just
trying to sum the first two sheets to see if it works.) If the value
in column A on sheet PD #whatever for any given row equals the value in
A8 then sum the values in column F of sheet PD #whatever.

If anybody has any help it would be greatly appreciated. I'm on
Windows XP and using Excel 2003.

Thank you!