Report to copy paste data based on matching criteria

Hi,

I've been asked to develop a report where people select certain criteria and then request the data matching that criteria to be returned. I've created an example of what i'm working with. I think the tricky part is going to be returning the correct price as it depends on the region selected (London or National).

To clarify i'm looking to build a report where people select criteria on the 'report' tab, upon request (prob a button) the report then looks for matching criteria on the 'data' tab and then returns that data to the relevant column on the 'report' tab. The actual data set i'll be working with will be quite large so I expect most searches to return a number of matches. The example i've provided should return two matches lines.

I hope this makes sense but if you have any queries give me a shout.

Thanks in advance,

Snook