=SUM(INDIRECT(A3&"!A1:A2"))

On Oct 22, 1:25*pm, Wombat wrote:
I want to make a formula in a summary table which will do a search in all the
other tabs in my work book.

The cell I want the information from is the same in each tab.

My problem is that at the moment, I am having to work on each formula to put
in the tab name in by hand. For example:

=sum(AAA!a1:a2)
=sum(BBB!a1:a2)

Is there a way I can spare myself having to type in the AAA, BBB, CCC part
in? I have all the tab names with the same formatting in the summary table
but I cant use a cell reference in the formula (eg: =sum('A3'!a1:a2))

Any ideas?

Thanks for any help :-)