I've looked around to try and resolve this, however I am unfamiliar with the coding.
Here's my line of code,
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)
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.