How to create a summary of macro created tabs

I have created a pricing workbook with 3 tabs: pricing sheet, equipment list and P&L projector. I then had to create a macro where you enter a # of buildings to be priced and it creates those 3 tabs for each building. Is there a way to automatically create a summary P&L Projector for all the macro created P&L projector tabs? I'm very inexperienced with Macros and VBA's so I apologize if my lingo is funny.