From Penny Fidelak@21:1/5 to All on Sat Feb 18 08:23:38 2023
I have a google sheet where I continously add new sheets (each sheet represents a different quote data but same design) I want automatically update the first sheet (summary) with a row that shows specific cells based on sheetname
example on the summary sheet
Row 3
Column b ='23-'$!H$6
Column c ='23-'$!b$6
Column d ='23-'$!g$4
Row 4
Column b ='24-'$!H$6
Column c ='24-'$!b$6
Column d ='24-'$!g$4
etc.
what I want to do is when a new sheet is entered a new row is added to the "summary" sheet without have to update every cell for the row?