I am trying to create a dynamic menu to sit on the left of every sheet in a workbook, which there are about 20. I have created the following for code, which works, if I have hard coded thhe destination.

ThisWorkbook.Sheets("sheet3").Activate

However I wanted the "sheet3" to be driven from a cell in a different "setup_sheet", this way I can change the setup_sheet and it filter through to the code. I had tried

ThisWorkbook.Worksheet("setup_sheet").Range("A1").Activate, but i reliase this is not right, but wanted to show I had tried