How can I create a summary tab using multiple tabs with similar data? I have laid out 3 tabs below, "John", "Andrew", and "summary". I would like the summary tab to look up off of over 50 different tabs. See below, thank you in advance!
Tab Name: John | |||||
A | B | C | D | ||
1 | Name | John | |||
2 | |||||
3 | Birth Date | 1/1/2005 | |||
4 | Favorite Food | Pizza | |||
5 | Sport | Soccer | |||
Tab Name: Andrew | |||||
A | B | C | D | ||
1 | Name | Andrew | |||
2 | |||||
3 | Birth Date | 12/6/2004 | |||
4 | Pet | Dog | |||
5 | Favorite Food | BBQ | |||
6 | Sport | Tennis | |||
Summary Tab | |||||
A | B | C | D | E | |
1 | Name | Birth Date | Pet | Favorite food | Sport |
2 | John | 1/1/2005 | Pizza | Soccer | |
3 | Andrew | 12/6/2004 | Dog | BBQ | Tennis |
<tbody>
</tbody>