Hi Everyone,

I have workbook which has 40 sheets, i want to place/move all the sheets in order as per the list of value in sheet1.
Note: Sheet names are different . i want to move the sheets from the value you place in sheet1, the value will be there in some sheet. So that sheet should move as per the list in sheet1

EG:
In Sheet 1 -- i am placing value in B2 column 20, 10, 30. And there are Three sheets named as A, B, C. In Sheet "A" in cell B2 the value 10 is there, In "B" sheet contain a value 20 in b2, In sheet "C" , B2 contain 30.
When i place 20,10,30 in sheet1, the sheet which cotains the values need to moved as per the list.


Can you please help to wirte macro or VB code.