Similarly, you may select cell B2 and drag the fill handle down to copy the formula for all the ... ways to pull specific data from one Excel sheet to another is to use cell references, where ...