I have a standard budget worksheet that has project budget information and several sub totals - it is basically a data entry to capture budget resourcing and pricing information. I need a new worksheet completed for each project. I want to link these project sheets up to a summary sheet that details some of the information and totals.

The issue is every time I get a new project I need to add a new sheet to capture the information and add a row to my summary sheet along with the formulas on the new line in the summary sheet to capture the new budget worksheet.

Any way to automate this?