Link Sheets

Hi,

I am trying to link two sheets in the same file. My first sheet is a master file with lots of information. I'd like to take specific columns of that sheet and link it to a new sheet. I am currently doing a copy/paste special. This works when I update existing information. However, when I try to add a new row in my master file, it does not appear in my second sheet. HELP!

Thanks