I would like a user to enter data to a workbook without directly accessing
that workbook.

In another workbook I have created in cells a1:f1 I have a formulas that
result in a cell references (these are variable), but for example say A1 =
$BT$150, $BU$150 etc.

I would like the value from cells a2 through f2 to go to Target workbook
$BT$150, $BU$150 etc

Thank you