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

You can use the IMPORTRANGE function in Google Sheets to easily copy data from one spreadsheet to another.