Excel Table that automatically links data to second sheet and updates automatically when rows are added

[rosiez7]

Hi there,

I am working on a spreadsheet that contains about 300 rows of data with employee names, start dates etc on the first sheet, within a table. I want to have this same list of employees on the second sheet, and possibly the 3rd - so I can add extra data for each employee that I don't want to show on the first sheet.

I saw the suggestion to copy and then "paste links" and that works well except it doesn't automatically update when I add new rows within the body of the table on the first sheet. Is there a way of doing this?

Thankyou so much!

R