I have a column that has tracking numbers. Each of those numbers has a tab that has the exact name as the tracking number. I need to create a formula that will allow me to use the value in the tracking number cell to reference a cell in that tracking numbers tab.
EX.
Tracking Number(Main - Col M), Date(Col N,sheet value depends on Col M)
[M1] DD-0250-2102-03, M1!A1, so I want it to be DD-0250-2102-03!A1
[M2] XX-3642-2402-03,
[M3] FF-5159-2402-03
I hope this makes senses. I pretty much need to use a cell value in my main tab as the tab name so I can get values out of those tabs.