I have an array of data that contains Suppliers, Projects, Priority, Contact,
Country (plus a buch of others that don't matter). Lets call this 'Data'

What I need to do is run a report that identifies each name in the Supplier
column and return the value to a new worksheet 'Report'

So, to put a picture on it, the data could be:

A B C
D E
1 Supplier Project Priority Contact
Country
2 S1, S2 Apple 01 High John
Australia
3 S3, S1 Orange 01 High Steve
Canada
4 S1, S2, S3 Peach 02 Medium John
Australia
5 S2 Mango 03 Low Max
England

What I need to be able to do is extrapolate this data to the 'Report'
worksheet based on the values in Supplier. So, the result in 'Report' based
on the above would be:

A B C
D E
1 Supplier Project Priority Contact
Country
2 S1 Apple 01 High John
Australia
3 S1 Orange 01 High Steve
Canada
4 S1 Peach 02 Medium John
Australia
5 S2 Apple 01 High John
Australia
6 S2 Peach 02 Medium John
Australia
7 S2 Mango 03 Low Max
England
8 S3 Orange 01 High Steve
Canada
9 S3 Peach 02 Medium John
Australia

Does anyone have an idea as to how or if this can be done?