Hello,

I am trying to SUM the total number of a specific colunm for a number of
different worksheets, in the same worksheet.

I.e. Sheets are named 'Ward 3', 'Ward 5' etc, and in my 'Total Contacts'
sheet I want to SUM up the column H3:H36 for each of those worksheets. So I
have been able to generate the correct formula for each worksheet
A B
Contacts
Ward 3 =SUM('Ward 3'!H3:H36)

Is there a way to use the text in column A to generate the formula in column
B. rather than copying and changing the formula?

Im not sure how clear the question is so please ask!!!

Thanks

Rup