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

If you want, you can copy the contents of an entire sheet from an Excel workbook in a few simple steps, then paste it into another sheet or program.