I have a formula referencing a cell in another workbook.

```
='[Workbook2.xlsx]5683-4'!$C$23
```

The `5683-4`

is a variable cell value in workbook 1 found at `A2`

. How can I build a formula where the the formula changes based on the value of the `A`

column?

For example:
If column `A3`

is `5683-5`

then the formula would populate

```
='[Workbook2.xlsx]5683-5'!$C$23
```