Hi,

I am creating a worksheet to do costings. I have a summary sheet, which I want to pull some totals from a sub sheet. I have this figured out, but would like to have a function to create a new sub sheet, which will automatically link itself to summary sheet, and pull totals from sub sheet. The template will start off with one subsheet, but could have up to 30. I would like a way where the user does not visually have to deal with a whole lot of unused worksheets, or manually link data when creating a new sheet

Thanks in advance, Tom