Hi, here's my situation ...

Workbook with ~30 tabs, sheetnames are a 3-digit number (some starting
with 0) + 1 tab which is to be a summary of the others. On each of
the 'base-data' sheets, range A2:A366 is a date, col B:Y are data
columns to be summarized. On the summary sheet, each sheet will have
12 rows -- col A as sheetname, col B as Month, col C:Z summed data
columns.

So, in Col C of the Summary sheet, the formula needs to go to the
correct sheet and sum the values in col B according to Month (as
derived from the date).

Any help is greatly appreciated!

Regards,
ray