For instance, to pull data from cell H2 on a sheet named Monthly Sales, you would enter this formula: 'Monthly Sales' !H2 A major benefit of using cell references is that Excel will automatically ...