Hi ,

Thanks for the quick reply. I need an out put like this.

Basically i have 35 sheets. In Every sheet at B2 cell there Project ID. I want to get all the project Id's of all sheets in the sheet1 of B column . And then in C Column i will be Prioritize like 1,2,3 etc and move the sheets as per priority.

So on click of button a need all Projects in Sheet1 of B column, after i prioritize in C column (1,2,3) Sheets need to moved as prioirtize

Example:
Sheet1:
B C
100 2
200 1
500 3

Note : Sheets names are Project's Names

** Iam not able to attach the excel. let me know how to attach tht excel