Auto popluate area name from unknown number of sheets

Hi JBeaucaire,
Thank you very much for the reply.
Please find attached revised workbook which will give a better idea of what I am looking to acomplish.
In it current form it is somewhat simplistic with only a few 'areas' (as in areas of a building), However my final workbook would have much more catogories, areas, etc.
So, the idea is, a salesperson would open this up (empty). Fill out the project name, address, date of bid and salesperson on the summary sheet. Then click the 'Add New Sheet' button on the Summary sheet. the user is given the option of imediatly after top or before bottom. Whichevers is fine. This then brings the user to the new sheet. I have the template such that it is reading the project info (name, address, salesperson and date) from the summary sheet. Then also in the new sheet (based on the hidden template), are sections for the salesperson to fill out. Namely 'Area Name' (such as basement, 1st floor, 2nd floor... as shown in my example workbook), and then the relevany costs for the area (based on set catogories, in my example workbook are set up as 'Demo work, Rough framing, Drywall, ...). The sum of the catogory costs for the area is added up in B19 of each area.
So, what I'm looking to accomplish is when the salesperson goes back to the summary sheet that each of the area names (pulling the info from cell B9 on the various sheets) would automatically be listed in column D with the corresponding total cost for the area (pulling info from cell B19 on the various sheets).
I then have the total sum for column E in cell B10 of the summary sheet.
I have for the purpose of explaining my desire entered the info I would want automatically pulled into columns D+E, but the hope is that this would be automated.
Thank you again for your reply. Please let me know if you require further clarification of the purpose or such.