https://youtube.com/watch?v=7T3i-RiuBBUExcel 3d formulas can be used to consolidate data from multiple worksheets into a summary sheet. 3D formulas aren't that well known except to advanced Excel users. If you ever…