extract a list from a range that meet criteria and update chart format dynamically

[sv1]

Hi all,
I'm attaching a sample workbook, one main sheet, and two others to extract some data from the "source" worksheet and plot charts.

The required are:
- search for text string in sheet "source", col. "item" and return a list of all items that start with "EG78" (unsorted).
- dynamic data series in all charts.
- I have a vba code to sort the column "result" descendingly, and also format the chart bars based on values, but it doesn't get updated automatically unless I edit any cell.

any help will be much appreciated.