SUM and INDIRECT to reference worksheet

[Potatosalad2]

I have 9 reference worksheets each titled by number and one summary worksheet with all nine numbers in column A. I would like to write a formula that references the number in column A, looks up the tab, and sums a column in that tab, say column B. I can get INDIRECT to work looking up an address ie: =(INDIRECT("'"&$A$3&"'!"&CELL("address",B2))).
But am having difficulties incorporating SUM where I can sum B:B.
Any suggestions would be appreciated.

Thanks

[Dav]

If the sheet name is contained in cell A3 then something like

=SUM(INDIRECT(A3&"!"&"B:B"))

should suffice

Regards

Dav

[Potatosalad2]

That works great. Thank you very much