I have devised a workbook with 13 sheets which shows expenditure month by month with a summarry sheet. Sheets 1-12 are for the months of the year and I have no problem with them but i cant get it to copy the expenditure total from a month cell to the summarry cell. the summary sheet shows all 12 months on one sheet but i need a formula to copy the data in a given cell on a monthly sheet to the summarry sheet bearing in mind the summary sheet location is different to the monthly cells as the sheet is laid out differently. I've tried the following =sum(sheet1.j3) or = (sheet1.j3) (wehere j3 is the location of data in the monthly sheets) but with no success Can anyone help please