Excel Table - Copy to second worksheet - paste link grayed out

[lkmw]

Hello, I have an Excel table that I want to copy to a second worksheet, and then delete selected columns and rows, and re-sort. But I need the data that is remaining to be linked to the original sheet so updates are automatically captured. One of the columns I am keeping will be email addresses, so I also want the hyperlinks to work, too. I've tried various options that failed. I decided to try paste link, however that is grayed out when I copy the table (the sheet is not protected). I also had a hard time trying to remove rows from the copied table.

Suggestions for the best method to accomplish this task? I saw some references to dynamic tables but could not figure out how to execute.

Thanks much.