What I need to do is to rename the created sheet (Products) with the name of the sheets in ws , that are used for the calculations (fill Products worksheet with data).
The format will be TEMPLATE-games-play2 etc , only the sheets with data
Please find attached an example
Create / Rename Worksheet based on other worksheets
Cross posted https://www.mrexcel.com/board/threads/…4/#post-5875738