Dynamically Transfer Data From Master to Sub Sheet

[BrettOlbrys1]

Hello. I have a master data sheet that gets fed data from a web form, and this master data sheet's rows will grow based on whatever number of times the form is filled out. I want to have a second sheet that gets fed this data, but only certain columns.

I don't want to place a formula in cell A1 on the second sheet and drag the formula down so that all of column A populates, I want the second sheet's columns to populate dynamically without the need to drag formulas into oblivion.

I know this is probably super simple, but how do I do this?

Thanks

 

[BrettOlbrys1]

Nevermind, I figured out that all I need to do is add a "+" to my range for the entire column to update automatically. Sorry for the stupid question.