Bringing column data to another sheet if critera met

[ashani]

Hi,

I wonder if someone could please guide me.

I have a 2 sheets in my spreadsheet called Sheet1 & Sheet2.

Sheet1 has all the data in 3 different columns, date wise- which looks like this :

All I want that in my sheet 2 when I change the date than it pull data from the 3 columns data to sheet 2.

Really appreciate your help.

Thanks,