Index Match Automatically

Hi all,

I'm after some help creating a index match formula in VBA, to populate a range of cells E-N based on column C, the index match will have to search multiple worksheets to find the correct Part Number.

I have some vba code which copies a 3 columns from a different workbook into 3 columns A,B,C & D but i want to search the workbook to populate columns E-N

I have attached my workbook for your assistance

Thanks.
ND