I want my Excel file to have 2 sheets with 2 tables.

I want the 2nd Sheets Table to be LINKED to the 1st (so when I update the
1st, the 2nd auto-updates).

Just FYI, Im planning to hide some rows/columns on the 2nd sheet, but still
want it to be linked to & auto-updated from sheet 1s table.

Is this possible in Excel?

Bob.