copying data between sheets

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

Hipaul
I tried your idea but it didn't seem to work. the sheets are all titled jan, feb etc so I tried =sheet"jan"!j3 but still doesn't work.

thanks for your help

David

Try Jan!J3 it should work

Sorry Above post should read =Jan!J3 in the cell you want it to tranfer to.