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

There is an option to insert a pivot table on a new sheet or an existing one. We recommend adding pivot tables to another sheet to avoid any confusion.