Sum the same cell across sheets

[Keep It Simple Stupid]

I have 30 different sheets and I need to somehow sum the value in B1 across every sheet. My sheet names are actually listed on my Summary Tab in column A if that helps.

So on my Summary tab I have in column A
A1
A2
B1
B2
B3
D2
D3... and so on

I don't care if its a formula or VBA. I just want the fastest way to do it. Sure, I could do it manually but I figure this will just be a good thing to know. Any advice is appreciated.

 

[VoG]

Try like this

=SUM(Sheet1:Sheet30!B1)

 

[Keep It Simple Stupid]

I knew there would be an easier way! Thank you thank you!!!
I love this website.