Hi John,

This great, it does exactly what I require. I have a small issue with the data content, which is, in Aug, June..etc worksheet there values under bs, cm...etc, which , are calculated using 'sum' formula and when I run the code, in the 'monthly' worksheet, the values get extracted as '#Ref'. Is this something easy to fix/or add in the code. Apology for the last minute trouble.

if you require further detailed example, on the above request, please do let me know.

Many thanks for your time.