$8$On the YearLinked worksheet, select cell A$4$ and create a linked consolidated summary based on position that links to the data to find the total number of items sold for each department each quarter. Reference cell range A$4$:H$20$ on the Q$1,$ Q$2,$ Q$3,$ and Q$4$ worksheets. Use the labels in Top row and Left column.AutoFit columns A:I and then hide columns B:C$.$ Select cell A$4$ type Item