My spreadsheet has two types of sheets:
1) A Statistics Sheet that automatically tracks data from Data Entry Sheets
2) A Data Entry Sheet. For example, A1 = Persons Name
I am trying to automate my Statistics Sheet, so that every time a new Data Entry Sheet is created, the Statistics Sheet will add A1 = Persons Name to a new row if it does not already exist.