Assuming that you have the data in
Sheet1 and the pipeline list in
Sheet2, you can copy the data from
Sheet3. Do the editing in
Sheet1, and any other sorting, such as by country, name, source, etc. and keep
Sheet3 as an automatically updated, and sorted view based on the pipeline.
Sheet3 with the needed column headings to match those on
A2 enter the formula:
You will need to adjust the following:
A2:E by replacing
E with your last column
D2:D by replacing
D with the column that actually has the status you are sorting on
6 in both
left functions with the minimum number of characters to make each item in the pipeline unique.
- the names of
Sheet2 if you have renamed the sheets to something more meaningful (as you probably should)
Adding and rearranging the items in the pipeline, as well as adding and editing rows on the main sheet, and inserting columns on the main sheet, are automatically accommodated by Google Sheets, so that you don't have to reformulate the equation for changes that you make in the pipeline, or for new entries in the data. (One exception to this: if you add a column to
Sheet1 you will need to change the header row in
Sheet3 to match.)
IMHO, as complex as this seems to be getting, you probably ought to look into switching to a database for this instead of a spreadsheet.