Linking summary to 12 worksheets

[Plopp]

Good evening,
I am trying to complete a workbook for my accounts and have reached a block. I have now got the 12 months how i want them, but am unable to link them properly to my summary.
can anyone tell me what i am doing wrong please.

Thanks Ploppy

[Bernie Deitrick]

I added the cells in yellow to your sheet, to allow the use of INDIRECT to pull the values.

[Plopp]

Good morning Bernie,

Thanks very much indeed. I really appreciate your assistance. Its simple when you know how!!

Have a good weekend John

[Plopp]

Good morning Bernie, I have entered a load of figures for October which have come up on the Summary but now All the rest of the Summary is showing an error? Is it something i have done? John

[Bernie Deitrick]

The values in yellow in column B of the summary need to exactly match your sheet names. In the original, you had "Sept" as a sheet name: it is now named SEP, so change Sept to SEP and you'll be good to go.

[Plopp]

Many thanks Bernie, I am busy learning Excel through Udemy and finding it very interesting but still have a way to go. Hope youre enjoying your weekend.

John