Insert formula in multiple worksheets & copy output to new sheet
 

Hi Guys,

I have a macro that when excuted:
- Formats a data sheet (inserting columns, vlookup from other files etc).
- Autofiltering and copying unique values to different worksheets and
renaming these sheets according to the unique value filtered (Thanks to Ron's
code).

I then add up these unique values to get a total in each sheet, which I
transfer to a summary sheet.

My problem is that every month I have different unique values, and hence
have different number of sheets. Also in each sheet the number of rows defer,
so putting a code in a specific line is also difficult. I was wondering if
someone could help me write a code for (a). finding the totals for columns B
- W in all sheets and (b). transferring it to a new summary sheet.

Thanks :)