Create Autoupdate Table/Pivot that sorts by colour or data source order

Hey

Please can someone help!

I have some data based on whether a check box is checked or not. (See attached screenshots).

If it is checked at level 3 it enters into a table that is coloured by the difficulty of the task, if it isn't checked it doesn't feed through/show and leaves as a blank cell.

I then need a table which auto updates when refreshed (so I thought Pivot table) but the pivot table won't allow me to sort by data source order or by colour, is there any other way for me to do it so that the data shows in the correct order?

Many thanks in advance

Kate

"If it is checked at level 3 it enters into a table that is coloured by the difficulty of the task"

What exactly is entered into the table? Where are the various tables?

"I then need a table which auto updates when refreshed"

Is this a different table to those mentioned above?

"sort by data source order or by colour"

What is the "data source"?

It will help a lot if you upload a small but representative subset of your workbook (not a screenshot) with any sensitive/proprietary data removed that illustrates the problem. A few manually calculated expected results would help make sure that any provided solutions match your expectations.

To attach a workbook, click on “GO ADVANCED” and then scroll down to “Manage Attachments” to open the upload window. Choose your file then click on “Upload”, scroll down then click on “Close this window”, then “Submit reply”.