Rename Worksheet based on worksheets

Hello all,

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

test6.xlsm

Thank you

Cross posted https://www.mrexcel.com/board/…ets.1203494/#post-5875738

Create / Rename Worksheet based on other worksheets

This is solved, so case closed.

Thank you

royUK of course!

Here is the solution

solution

With help from https://www.msofficeforums.com…sed-other-worksheets.html