This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I found a solution, but it relies on the Filename containing the sheet name, which is fine for my use case.
I modified the Batch macro idea from this post The Ultimate Input Data to include a Formula before the Batch Macro that creates [Table] as the table name and then configured the Macro to choose [Table] as the control parameter. See below screenshot
I also modified the Action within the Macro to "Replace a specific string" - see second screenshot.
So the Macro will replace the specific string "CustomerReport_27022018130050" with whatever appears in [Table]