How to connect INDEX MATCH formula with FILE open Dialog ?

[Elvis16]

I have this formula:

=INDEX(Tabelle1!$D:$G;MATCH(1;(Tabelle1!$F:$F=A9)*(Tabelle1!$D:$D=E$1)*(Tabelle1!$B:$B="Mo

tor");0);4) which works perfectly fine.

What I want is to create a VBA Code that does the same function as INDEX MATCH just between the worksheet I Need to connected with different workbook, but since the workbooks come every three months and they are completely new (Same Format tho).I want to create a open file Dialog which allows me to select the file and copy the values that are shown in the formula.I am new at VBA Code and cant seem to Format it.
Any help will be much appreciated !
Thanks<strike></strike>
​

<strike></strike><strike></strike>
​

​