Can I mirror a column in one sheet to a column in different sheet?

Assuming the table in sheet 1 is called "table 1",

In the second sheet, put this simple formula into all cells of column A of the table in sheet 2:

=Sheet 1::Table 1::A

That is the most simple way but it will put zeros in cells where Sheet 1::Table 1::A has blank cells. A more sophisticated formula is:

= IF(Sheet 1::Table 1::A<>"",Sheet 1::Table 1::A,"")

Hmm. Do you mind if I call it Table 1 and Table 2 vs "the table on Sheet 1" and "the table on Sheet 2"?

No formula will create additional rows in a table. No command will create additional rows in multiple tables at the same time. An Applescript written specifically for your circumstsances could create rows in more than one table.

While the formula cannot add additional rows to Table 2, if you add a row in the middle of Table 1, it should shift everything down on Table 2 just as if you had added a row in the same spot. You have to use the whole column reference "A" in the formula, not A1, A2, A3, etc.

If you are adding additional rows, you will need to make Table 2 a lot longer than Table 1. Every time you add a new row in Table 1 it will use one additional "empty" row of Table 2. When Table 1 becomes longer than Table 2, Table 2 will not get the bottom rows of Table 1. The formula will have to be modified to eliminate error triangles when trying to reference rows in Table 1 that do not exist. You can create a filter to not show the extra rows:

=IFERROR( IF(Sheet 1::Table 1::A<>"",Sheet 1::Table 1::A,""),"END OF TABLE")

If desired, create a filter for column A of Table 2 to show rows only where text is not END OF TABLE.