Copying and updating formulas
 

I have a workbook with mutiple sheets, each corresponding to a date. I
use a formula [f4 of the actual sheet= h4 of the previous] which is the
actual stock, based on the remainig of the previous. I would like to
have a way of copying the formula to all sheets and updating
automatically. Actually I have to do it one by on.
Many thanks beforehand
Dimitry