Formula help to return stats from multiple sheets

[magpie2000k]

Guys I am working on a spreadsheet and need to buils a search page.

I have 5 tabs where the columns are
[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Surname[/TD]
[TD]Age[/TD]
[TD]URN[/TD]
[TD][/TD]
[TD]length of service[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Smith[/TD]
[TD]33[/TD]
[TD]qz445566779[/TD]
[TD][/TD]
[TD]3 years[/TD]
[/TR]
[TR]
[TD]julie[/TD]
[TD]Paige[/TD]
[TD]27[/TD]
[TD]fd4775h33[/TD]
[TD][/TD]
[TD]2 years[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Smith[/TD]
[TD]34[/TD]
[TD]ttt6767655[/TD]
[TD][/TD]
[TD]6 years[/TD]
[/TR]
</tbody>[/TABLE]

The sheets are location ie London Brazil new york Athens

I want to build a search page where I have the first four fields if B2 c2 d2 and e2 and the cells to enter the info in b3 c3 d3 and e3

I want the results to return underneath

[TABLE="width: 500"]
<tbody>[TR]
[TD]London[/TD]
[TD]

qz445566779

<tbody>
</tbody>

[/TD]
[/TR]
[TR]
[TD]New York[/TD]
[TD]None[/TD]
[/TR]
[TR]
[TD]Brazil[/TD]
[TD]ttt6767655[/TD]
[/TR]
[TR]
[TD]Athens[/TD]
[TD]None[/TD]
[/TR]
</tbody>[/TABLE]

What I am really hoping for is that if I dont have all the information to type in to the search fields ie I know only bob Smith it returns the results shown above, but if I know the age is 33 then it would update the results so that I only get the answer in the box next to london. But also that I could just type in the URN (unique reference number if known and get the complete answer.

I hope this makes sense...

oh and on the search page in colum a

You have the cities written.

One last point.

Staff move and as such the same bob smith could have worked with same urn in 2 locations I would like to add length of service in the returned result where that happens