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

[cwcpoppa]

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.