Linking worksheet info to main work sheet

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

Thanks FDibbins,

I thought that might be the case. Could you point me in the right direction for any resources related to this? I am a newbie to VBA, so even a sample of similar code to give me an idea how to start would be helpful

Cheers, Tom

Awesome, thanks for that