I manage a building business and have developed an excel based job costing workbook with multiple spreadsheets. Each spreadsheet represents a job and all spreadsheets are referenced to a summary spreadsheet to sum up all jobs in progress including payments received. I would like to automate the workbook so that i can automatically add new spreadsheets and the formulas will automatically update in the summary spreadsheet. I would also like to add buttons so that I can add new rows and colums without comprising the integrity of the spreadsheet. The summary spreadsheet also sets out the labour and overhead rates that need to populate every new spreadsheet. Each spreadsheet needs to generate a pie or bar graph that illustrates job progress and actuals vs. budget.