Need help with creating VBA code to lookup return values in spreadsheets

I have 3 workbooks "ID numbers, 07 Car,and 08 Car".

I need a VBA code that will use the value in column C in each workbook, look up the value in workbook "ID numbers", column C thru G, and return
values into each workbook:

Workbook ID number Column C add values to Each workbook (Column B)
Workbook ID number Columns D thru E) add values to Each workbook (Columns D thru E)

See 07 Car workbook highlighted in orange, every product below the orange highlight must look like for both workbooks this after the code is ran.

See my enclosed example

thanks
for all your help
Chad