how to add a button on my summary sheet which auto makes a new sheet and logs the information in the summary sheet

Hi there,

I have attached my spreadsheet,

I have made a button on the summary sheet which what I want is when i push that button, a new breakdown sheet opens just like the Mainswitchboard

sheet I have made, and when it opens i get to automatically name the sheet and the summary sheet updates under breakdown with that sheet name, I also

need the information in the associated row to automatically fill in, the Labour hours, labour cost, material cost and total.

can this happen?

AttachmentSize
TENDER SHEET.xlsx153.78 KB