Your missing the qoutes

=SUM('Sheet1:Sheet3 (2)'!A1)

You needs those if there are spaces in the sheetnames.