create_a11ytable() will warn if you have notes (in the form '[note 1]') in a table (headers or cells) that aren't in the notes sheet, or vice versa. Double-check whether this takes account of notes that may appear in the title (cell A1) but not in the tables themselves. Also, does a sheet with a note in its title, but not in its table, have the 'this table contains notes' line inserted? Should it? Maybe the line should read more like 'this sheet contains notes'.
create_a11ytable()
will warn if you have notes (in the form '[note 1]') in a table (headers or cells) that aren't in the notes sheet, or vice versa. Double-check whether this takes account of notes that may appear in the title (cell A1) but not in the tables themselves. Also, does a sheet with a note in its title, but not in its table, have the 'this table contains notes' line inserted? Should it? Maybe the line should read more like 'this sheet contains notes'.