Should be able to get the formulas on each sheet by selecting all the
sheets prior to writing the formula.
Hold the shift key down and click on the sheets you want to have
together.
When you link data together on different work bookes when you open the
parent it should prompt you to update the data, generally speeking you
will want to say yes.