When working with multiple sheets in an Excel workbook, you may need to reference data from one sheet to another for calculations, analys…