To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

How Do I Reference a Cell in Another Worksheet in Excel?. Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects.

It is possible to make the Sum Excel formula reference another sheet, or multiple sheets, and add up a range of cells across those sheets.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.