help with vlookup or index or match or what?

[rcirone]

I have 4 taps
1. Two-Ten tab
2. Loc tab
3. Purple Tap
4. Data Dump Tab
I am try get the info from data dump tab to all the other taps with the right Program. if you look at the pic you will see what I need to do please help I do not know if I use vlookup index or what?
Sorry but I can not change the order of the data dunp Tab.
Please Help?

 

[rcirone]

Still will not work for me Data Dump Tab has formula in the cell pulling info from other sheets is that why it does not work

 

[Aladin Akyurek]

Still will not work for me Data Dump Tab has formula in the cell pulling info from other sheets is that why it does not work

Could you upload your wb to dropbox or something similar?