How do I link cells from a workbook, to talley one one sheet?

[Hammer]

I have 12 (Months)worksheets in a workbook. I need the selected cells on each
worksheet to tally on a 13th (Yearly Results) sheet. Been fussing with it
for days now. Cant get it! Help!

 

[Ron de Bruin]

Hi Hammer

Try this with code
http://www.rondebruin.nl/summary.htm

If you sheet have names like Sheet1, Sheet2, Sheet3 then you can do it also
manual if you want