This article explains how to reference data from another worksheet in Google Sheets.

The most common reason people want to pull data from another worksheet in Google Sheets is when those other tables are lookup tables.

For example, one sheet might contain all the products you sell, along with their UPC codes and unit prices, while another sheet might contain a log of your sales. To calculate total sales, you need to pull pricing data from the product sheet. Here's how:

In the original worksheet where you want to extract data, place the cursor in the cell where you want to place the data.