Self populating data sheets

Hi,

I wondered if it is possible to populate a sheet dependent on cell values in another sheet.

I hope the sample sheet I have designed is self explanatory.  The answer if there is one would be an enormous help in a bigger project I am working on.

Ideally I would like to use formula but it may be that VBA is the only way.

Thank you in advance for any help you can offer.

Paul