Good Morning Rudi,
Thanks again for your help.

I now have sName populating along with iCol ( this was my fault as the name on one sheet had a "." after the name, sorry) but YearEndFigures = EMPTY.

YearEndFigures is at the moment> =SUBTOTAL(109,G$3:G$81) but as rows get added the G$81 goes to G$82, etc, and its the resulting value that I would like.

Keith