lookup Col and display in order

Seeking your assistance again please
Attached workbook example tried to explain what I am seeking to do
1. Using references in a Column in various zones I am seeking to be able to show then print the list minus the blanks
2. There will be occasions where the same material is used more than one [it still should show on the order of the column

As always assistance appreciated