Hi

I would like to ask your advise on the best approach for analysing multiple
spreadsheet.

Allow me to explain. There are ten sheets with data in A:A which is the
result of a formula. All the data in A:A in all sheets must have the same
data.
What is the best way to compare the sheets to see what data may be missing
so it can be updated for a given sheet.

Hope I have explained what I am looking to do clearly enough.

Thank you!