JavaScript code to be used in AppsScript, an extension of Google Sheet, which records values from all tabs in a spreadsheet and generates a summary of it. Don't forget to adapt the code to your worksheet. Rows and columns will need to be changed in addition to names.