How to create a summary of macro created tabs

**jklovensky** · 08-30-2016, 11:15 AM

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.

**shg** · 08-30-2016, 12:23 PM

Welcome to the board.

Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

Thanks.

EDIT: Thank you.

**shg** · 08-31-2016, 02:22 PM

Can you post a workbook with an example of what you have and what you want?

**jklovensky** · 08-31-2016, 02:48 PM

Yes and thank you. I hope it attached correctly.

If you go to the Start Here tab at the very top and enter the # of buildings and then push the star, it'll create tabs for each # of buildings. After
I've entered information for each building, I would like to be able to create one summary P&L, pulling information from any macro created P&L's. Am I
making any sense? Can Excel do that?