Formula that will allow data to be obtained from sheets as they are created.

The first page of my workbook is a summary sheet.  Each time I run my macro it builds a new estimating sheet.  I could make a limitless number of estimating sheets per workbook.  I am trying to make a table (that I am limiting to 15) on my summary sheet that gives me each individual job total separately vs. a "sum of".   Can this be done by a formula, or do I need a macro.  I would prefer not to use a macro for performance reasons, but if I need a macro, do I need a separate macro for each cell?  Lastly, can I make the macro auto update as data is entered?