I need an excel formula

I need a formula: I will be recording various data points in the "data" sheet every day. I need the data to pull through to the "KPI" sheet - I need it to automatically correlate to the corresponding days between the KPI and Data sheets, update as the days change etc