Hi ,
I have a workbook containing the 100 sheets each are not in order of precedence, I have precedence order defined in the first sheet which is named as "Executions" and it has list from A2 to Last row of it. so, for example, now A2 has string value as "Apple is Red" and that string exists somewhere last sheet in particular cells in Each sheet then re-order based on the order of "Executions" Sheets.
Please view the attachment which has more detail.
Thank You
Bookmarks