I have created 8 worksheets within a workbook. Each worksheet with in the
workbook represent an employees data abstraction works.

So what I need to do is take the following:
=SUM(Amini!M$2+Blazer!M$2+DiSalvo!M$2+Hensel!M$2+M engon!M$2+Rees!M$2)

And change the Column up to N, O, P....etc:
e.g.
=SUM(Amini!N$2+Blazer!N$2+DiSalvo!N$2+Hensel!N$2+M engon!N$2+Rees!N$2)

I can't find a way to up the column as I drag to update the column.

Thank you in advance!!!

--
Thanks,
Andy