Good afternoon,

I have a €˜yearly totals page in my workbook which is the first sheet and it
SUMs the totals from two other sheets and places the total in column B, row A.
Column A has a heading called €˜ABC Yearly Totals

The two sheets called €˜ABC new and €˜ABC old, at Column B, contains
numerical totals in a cell that changes monthly but the column always stays
the same. (Column B)
Column A has a heading called €˜ABC Monthly Totals

Is there anyway I can have the formula on my Yearly totals page look for the
heading in row A on the ABC pages and add the totals from both pages that are
next to the heading €˜ABC Monthly Totals in column B?

This way, it wont matter if the row changes from month to month.

Thank you in advance folks for all your hard work in this matter.

BadBoy