Put this in C6:

=SUM(INDIRECT("'BDM"&TEXT(ROW(A1),"000")&"'!M:M"))

then copy it down as required.

Hope this helps.

Pete

On May 20, 9:17*pm, robzrob wrote:
I've got =SUM(BDM001!M;M) in C6, ie referring to column M in worksheet
BDM001. *In C7, I want =SUM(BDM002!M:M0, ie referring to worksheet
BDM002, in C8 I want =SUM(BDM003!M:M), etc. *How do I copy down?