Any advice on how to set up 2 worksheets so that they have the same
first column of data (A:A), but any changes, insertions or deletions
to column A on worksheet 1 will be matched by changes to worksheet 2?

Bit like a database of 2 tables really.

Thanks, Chris