Hi everyone,

I have a workbook with many sheets, most of them being financial
information, ie last year actual / budget, this year actual/budget etc.

I then have a sheet which I am making a report on to summarise all of
the other information. Each line is a sumif of all the relevant cost  /
income types. Ie office expenses would be a sumif on all the expense
classified as office expenses.

What i want (need) to do is have a drop down box where users can select
the data they want the report to be populated with. Ie they can select
last years budget numbers and all the sum if formulae will be
calculated off last years budget sheet.

I think the way to do this is with the indirect formula within the sum
if, but I can't seem to get the syntax right.

Normally I would just have
=sumif(bud0506!$g$g,sheet1$a$1,bud0506!$i$i)
so I want the sheet to be dynamic, so i have a drop down menu linked to
cell a2, so cell a2 would have bud0506 in it, so i then would have
=sumif(indirect($a$2&$g$g),sheet1$a$1,indirect($a$2&$i$i)

But I just can't seem to get the syntax correct, any help would be
greatly appreciated.