Dynamic Sheet Naming, Macro reading sheet name unknown variable error

[JCornn]

Thank you for helping in advance. I am running into an error when trying to have sheet names dynamically assigned, Comprised of 2 macros the first is fed a file path to generate sheet names output that is then read by the second macro

The issue I am running into is when the the 1st macro is initiated it says the sheet name column is an unknown variable.  I have created many similar macros and do not understand why this error is occurring.

Error:

(1st) Sheet Naming Macro: Pulls sheet names and creates path for correct sheet name

(2nd) Main Macro:

Formula causing error: (The only operation performed by the select tool is naming [Sheet Name].)

Let me know if I can clarify. Thank you!

[csmith11]

The Variable Should Likely be [Sheet Names]  with an s.

Please let me know if this resolves your issue.

[csmith11]

[JCornn]

Thank you for the reply!

Unfortunately the error was originally occurring with the variable [Sheet Names], so I renamed to [Sheet Name] to remove naming as a possible fix. 

[csmith11]

Hmmm. Can you share the full list of messages errors and any other warnings? 

From your main workflow can you enable the following: