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.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Client ID[/TD]
[TD]Name[/TD]
[TD](Data not needed)[/TD]
[TD](Data not needed)[/TD]
[TD](Data not needed)[/TD]
[TD](Data not needed)[/TD]
[TD]Meeting due by[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Client ID[/TD]
[TD]Name[/TD]
[TD]Meeting due by[/TD]
[TD]Caseworker[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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