Hi, I need help with specific sorting of pictures.
PDpbs74.jpg

as you may see from the picture, I have few bullet charts which are CAMERA function output (live pictures). Each of bullet chart is made from separate sheet (KPI1, KPI2, KPI3, etc)
I need to have some kind of sort function which would look, what kind of perspective the chart uses (1. financial, 2. customer, 3. process or 4. people) and sort all of pics in the order:

lets say:
1. Financial
1. Financial
2. Customer
3. Process
3. Process
4. People

it would depend on the way the chart is used. for example if someone adds data to the cells which make that bullet chart and it is used for Finance perspective, that person choses from drop down menu what kind of perspective it is. In this case, I think to add cell values under the chart in initial KPI sheet or in this BSC sheet (under the camera picture) and later to sort it in needed way.

what would be the best option for that?

hope I described the problem in understandable way?