Tab issue

[jerry8989]

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.

 

[DonkeyOte]

take a look at the INDIRECT function in XL Help.

 

[jerry8989]

Thanks for the help I got it.