Want some data from one spreadsheet to auto populate on another.

Hello!

I have a shared spreadsheet with two tabs, and I want some of the columns on that spreadsheet to autopopulate to another sheet which is not shared for my own use if possible. Does anyone know how to do this?

I want some of the data on Sheet 1 to autopopulate live on Sheet 2 and I am not even sure if it is possible. Any assistance would be so appreciated!