First thing, John, is that a formula cannot "push" data to another
cell, rather it has to be "pulled", which means that you need formula
in your second sheet to drag information from the first.

A simple formula like =Sheet1!A1 can be used to pull information from
cell A1 of Sheet1 into the cell that contains the formula. There are
other functions like MATCH( ) and INDEX( ) and the various lookup
functions which can be used to search for data which matches some
criterion (like date).

However, for us to help you directly, we will need some more details of
exactly what it is you want to do, so can you post these details?

Pete