Although you used $3-$D references to pull in quarterly sales for each department, you want to create a comprehensive worksheet displaying monthly sales for the entire year. You will use the Consolidate tool.

Display the Consolidated worksheet. In cell A$1,$ use the Consolidate tool to select and add the range A$2$:E$11$ in the Qtr$1$ sheet, Qtr$2,$ Qtr$3,$ and Qtr$4$ worksheets. Use the top row and left column labels. Do not create links.