Are there any formula That can be used to pick up the totals on individual
sheets and show it in a tabular form on one sheet eg if each sheet
representing a department has expenses, say light, water, telephone for
twelve months. All I need is the total for the year for each expense for each
department on one consoludated or summary sheet. The expenses are on
identical rows for each department.

The final product should look like.
HR IT Operations

Light 100 150 200
Water 50 75 100
Telephone 80 120 130