I have a workbook with a large number of worksheets, all
of which are in the same format. The sheets are named by
employee. I would like to sum various cells across the
workbook onto one sheet, eg sum all L48 cells across the
workbook.

Is there a quick way to do this either by formula of
macro? I don't really want to have to create one long
formula by manually clicking through and selecting L48 on
each sheet.

Thanks for any help.