Unhide and name sheet based on range of cells

Hi guys

I need help

Sheet1 named "Names"
Sheet2 named "Results"
Sheet3 to Sheet50 each memeber scores


I put names in range B3:B53 in the "Names" sheet, those names get copied to the cell range B3:B106 on the "Result" sheet, there are some blank cells between each cell.
Sheets3 and the rest are hidden.

I need VBA code which would:
1. Unhide Sheet3, Sheet4,... based on input to cells from "Result" B3:B106,
2. Name the sheets based on cells from "Result" B3:B106

Thanks very much

My suggestion:-

In order for your changes to the "Result" sheet to be picked up by a Macro I suggest creating another worksheet, which stores the historic values of "Result" (not linked. In the first instance copy and paste values, then leave it to the macro to update as necessary)

On starting the macro it will compare the data from one with the other and therefore pick up any changes you have made.

The same macro could then unhide the relevant worksheets, rename them and update the data held in the historical worksheet.

Finally another macro could be used to then close all the open sheets.

Hope this suggestion is a helpful start.