Laca,
try the following:

=SUM(INDIRECT("'Dept"&ROW(1:10)&"'!A5")

which is an *array* formula (you must commit with Shift+Ctrl+Enter).
This one will definitely ignore irrelevant sheets.

HTH
Kostis Vezerides