I've looked around to try and resolve this, however I am unfamiliar with the coding.
Here's my line of code,
='[WorkBook]BOM'!G6
What I want to do is make the Workbook call to a cell so I can mass replace all the 'Workbook' names without Find and Replace.
Essentially, something like this (Though this code does not work, it is just for reference)
='[=E1]BOM'!G6
Then in cell E1, I would be able to enter any text I want, to replace the Workbooks name. I'm trying to find the Formula to do this.