What is tyhe best way(without vba) to copy all data in a column from one sheet to another.

Here is what I am needing to do

Dates are going across in cells A1:Z1
Data is below each date from A2:A57 and so on.

On a seperate sheet I am trying to copy an entire column based on the date. So If the date given is in G1 then all of the data in column G will copy from sheet1 to sheet2.

Thanks for the help.

TB