Help with advanced date functions in excel 2010.?

Hold down the Shift key and click the tab of the other Sheet. Now both sheets are selected and everything you do will be reflected in both of them.