Lookup sum of values for different sheets

[bboeseabc]

I have ten different worksheets with sales numbers for each month. On a seperate worksheet, I have a list of the different worksheet names. I would like to do the following.

1) Look up the value for a specific month from that respective worksheet by looking up that specific worksheet.

Would a VLookup be the way to do this?

Thanks!
Brady

[FDibbins]

Hi, welcome to the forum

Would a VLookup be the way to do this?

Probably, (with the hep of the INDIRECT() function), but hard to say for sure without seeing some sample data.

If your data is all formatted the same across all sheets, then a simple + might do, too

Do you have a (clean) workbook to share?

[bboeseabc]

I don't have a workbook to share, but thank you for replying. I ended up keying each formula in seperately like this.

=sum('Sheet1'!b5:b12)
=sum('Sheet2'!b5:b12)

Could you tell me what the (!) does after the name of the worksheet?

Thanks,

[hoyasaxa215]

Just indicates a different worksheet name.