If you have data across multiple Excel worksheets that you want to bring together in a formula, don’t waste time manually referencing each cell. Instead, use an Excel function called 3D referencing, which helps speed up the process and ensure you don’t accidentally exclude any cells.
Source : How to Reference the Same Cell Across Multiple Excel Sheets (3D Referencing)