Excel help

[Mark M]

I have a workbook with 52 weekly sheets in it. I need to summarise the figures from each sheet onto one. Each week I need to pick up a total from, say, C30 (which never changes on each sheet. Is there a quick way of doing this?

Thanks for any help, Mark

 

[Mark M]

Yeah but I dont want to have to type out each formula 52 times. Was just wondering if there was a quick way of doing it?