Need Help,

I have a Totals sheet with several worksheets that represent projects. The
number of worksheets(projects) will be added or deleted depending on project
completions.

What I'm trying to do is have a Macro to run that will count the number of
worksheets (since the number is not constant) and force the formula -
+ 'sheetName" !B2 + 'sheetName' !B2 - into cell B2 on the Totals sheet.
Can anyone help