Trying to sum the number in cells from multiple worksheets

[The Batman]

I'm trying to sum the B2 cell in multiple tabs within the same workbook and it isn't working for me. So far my formula looks like this:

=SUM(B2,'WK 1 Summary'!,B2,WK 2 Summary'!B2,WK 3 Summary'!B2,WK 4 Summary'!)

I've also tried it like this:

=SUM('WK 1 Summary'!B2,WK 2 Summary'!B2,WK 3 Summary'!B2,WK 4 Summary'!B2)

Can anyone please tell me why this isn't working?

[Fluff13]

On your 2nd formula you are missing the apostrophe from the start of the Wk2, 3 & 4 sheet names, they should be the same as the Wk 1

[The Batman]

I got it to work with this:

=SUM('WK 1 Summary:WK 4 Summary'!B2)

Thanks all!

[Limor_OP]

=SUM('WK 1 Summary:WK 4 Summary'!b2)

[The Batman]

Is there a way to do this in a particular cell across multiple workbooks (spreadsheets?)

The reason I ask is that there are 3 spreadsheets that each agent in my department uses to track their cases and I want to pull stats from their overview tabs into a totally different spreadsheet that will record the totals for the entire department.