Tough One! VBA namebox issues

[MichaelRSnow]

Hi there

Got a tough one for me

I have 2 workbooks
Workbook A - cell Value in A1 = 'SIB01'
Workbook A - cell Value in A2 = 'Open'
Workbook B - cell named 'SIB01' (via NameBox function)

I want a vba that copies value from A2, workbook A into the equivelant namebox in workbook B, but it only know the name of the namebox because it pulls this from the value in cell A1 workbook A.

Hope this makes sense? is it possible?