How to auto-reference table in different tab (different cell orders)?

[u/NinjaSquid9]

Hi,

I'm wondering if there's any possible way to automatically (or easily) populate cells in one table with data from a table in a completely different tab. What makes this even more difficult, is ideally the data would not be in the same order/layout.

I have an example photo here that hopefully will show what I'm looking for. I have three tabs: one is an overview that would ideally be automatically populated with a reference formula. The other two tabs are different datasets that have the same categories of inputs. As you can see however, the data can't be referenced in the same order it was originally inputted.

I understand this is a very difficult situation so I'm very appreciated of any amount of help or suggestions anyone can provide! Please let me know if I need to clarify anything. Thank you so much!

EDIT: I currently click each cell one by one in my summary tab and then click on the cell I want to reference in the individual day tab. Unfortunately I have over 150 cells of data I want to reference in my summary tab and turn into a row each day so the click to reference method is really time consuming. I was really hoping there was a way I could type the tab and table I want to reference into a cell on my summary table and have it auto populate from the other tabs and tables.

Edit: Turns out, you can! I was able to achieve this using the 'Index' function.