Pull data from one spreadsheet to another

I have a very large spreadsheet with multiple columns. How do I get another spreadsheet to pull data from certain columns into a new spreadsheet, and update itself automatically when data is entered into the first spreadsheet?

Hi,
have you tried : - Copy - Paste Special - Paste Link?