Copy date from one WB to another based on matching ID?

[Jaxven]

I'm sure I knew how to do this once

Ok so I need to take the date from workbook 1 column G to workbook 2 column c based on matching I.D'S in column A

In workbook 1;

Client ID is in Column A, between 40-60 records at any one time.
Date of next meeting is in column G.

	A	B	C	D	E	F	G
1	Client ID	Name	(Data not needed)	(Data not needed)	(Data not needed)	(Data not needed)	Meeting due by
2
3

<tbody>
</tbody>

In workbook 2;

Client ID is in Column A
Date of next meeting needs to go in Column C, to update when workbook 2 opened.

	A	B	C	D
1	Client ID	Name	Meeting due by	Caseworker
2
3

<tbody>
</tbody>

Can this be done?

I also need to be able to populate the table in Workbook 2 with any new entries to Workbook 1, with only selected cells from each row (ie not all the data, just 4 columns out of 15).

Thanks in advance for any help you can offer