Question: how do you pull data from one excel tab to another?
Answer: Link Spreadsheet Cells with ! To reference a cell from one sheet in another, all you need to know is the sheet's name and the cell's name. Link them together with an exclamation mark. Say your sheet's name is "Names", and you need the data from cell B3. Just enter =Names!