Import Columns Based On Row Headers And Matching

I have a nice little code which imports data from a mastersheet to my input sheet. Though it will only work as long as the mastersheet is static.

I'm trying to match the product code in column A between my mastersheet and my workbook with a input sheet. And then copy the cell value in column D and E of the relevant row.

The messy part is that some of the products are split into sub categories (less than :$$$:, between :$$$: etc) and they dont have any info in column A.

I'm unsure if this is doable. Is it? And if I get permission to edit the mastersheet somewhat.

I tossed in the start of my currect static c/p, thought I don't think I'm keeping it if I get a handle on this match macro issue.

Code:
Dim ws As Worksheet, wb As Workbook, t As Date, wb1 As Workbook, wb2 As Workbook, wbName As String, janei As String, spm As String
Dim fil
Set wb1 = ActiveWorkbook
ChDir ""

[Code] .........