VBA Copy data to another work book based on CONDITIONS

[Giggs1991]

Hi Team,

I would like to copy data from one work book to another. The data has to be copied from BookA to BookB.
However, the issue is that I am not allowed to edit the vba in BookB.
Book A has a list of names and their forecasts.
Book B also has a list of names and forecast but it also has a section for Actuals.
The names in Book B are also in a different order.
The VBA code has to run from Book A since I am not allowed to code on Book B.
The actuals section in Book B should remain unaffected by the macro

BookA

forecasts

Name dec-19 jan-20 feb-20
jack 100 200 300
john 150 250 350
max 175 275 375


Book B location : C:\Users\Giggs\Desktop\2019report
Expected output :

BookB
Actuals
Name dec-19 jan-20 feb-20
jack
john
max

Forecast
Name dec-19 jan-20 feb-20
max 175 275 375
john 150 250 350
jack 100 200 300