Taking data from specific tab by using a reference text cell

Hi,



I have an excel file that is an invoice where i need to bring data from another excel file but it can be from different tabs and also the columns position may differ, only the column header will be the same.

The invoice number looks like this for example: T9CO-FB-7-0101-MD1-01/CW13232. The mid part(0101-MD1-01) is also the name of the tab where the information from the other excel files should be extracted from. I made a formula that returns me in a cell, the exact name of the tab, from the Invoice number. So i need something that can go and find the tab by using my formula as a reference, and also look for the column where the data should come from, by the headers name, and bring me the Total Price using the reference Tag number(which will be manually completed in the invoice file).



By now i had this:

Please Login or Register  to view this content.

But it doesn't seem to work.
Please help
Thanks !