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?

Here are the examples.

Spreadsheet 1: https://docs.google.com/spreadsheets/d/1KzDs0cyc6B46XROkjhYoqR9-k1LKhBh1aUaNfEtJRpo/edit#gid=2100307022

​

Spreadsheet 2: https://docs.google.com/spreadsheets/d/15jEh5zHyADdm5WGfdm5bdFSn-Tg8rrWpQ7w8hYmtKXs/edit#gid=2100307022

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!

Thanks

Christine