The Tip Left column in the Friday worksheet contains a fill color and number formatting. You want to fill these formats to the other daily worksheets.

Group the Friday through Monday worksheets, staring with the Friday worksheet. Fill the format only for the range E$5$:E$24.$

Now you want to insert column totals for the five worksheets simultaneously.

With the worksheets still grouped, insert SUM functions in the range B$25$:E$25$ and apply the Totals cell style. Ungroup the worksheets.

The Week worksheet is designed to be a summary sheet. You want to insert a hyperlink to the Total heading in the Monday worksheet.

On the Week worksheet, in cell A$5,$ insert a hyperlink to cell A$25$ in the Monday worksheet with the ScreenTip text Monday's Totals. Test the hyperlink to ensure it works correctly.

In cell A$6$ on the Week worksheet, insert a hyperlink to cell A$25$ in the Tuesday worksheet with the ScreenTip text Tuesday's Totals. Test the hyperlink to ensure it works correctly.

In cell A$7,$ insert a hyperlink to cell A$25$ in the Wednesday worksheet with the ScreenTip text Wednesday's Totals. Test the hyperlink to ensure it works correctly.

In cell A$8,$ insert a hyperlink to cell A$25$ in the Thursday worksheet with the ScreenTip text Thursday's Totals. Test the hyperlink to ensure it works correctly.

In cell A$9,$ insert a hyperlink to cell A$25$ in the Friday worksheet with the ScreenTip text Friday's Totals. Test the hyperlink to ensure it works correctly.

Now, you are ready to insert references to cells in the individual worksheets. First, you will insert a reference to Monday's Food Total.

In cell B$5$ on the Week worksheet, insert a formula with a $3-$D reference to cell B$25$ in the Monday worksheet. Copy the formula to the range C$5$:E$5.$

The next formula will display the totals for Tuesday.

In cell B$6,$ insert a formula with a $3-$D reference to cell B$25$ in the Tuesday worksheet Copy